Replacing sequencially all characters by a specific character

[mlektra]

Hi guys. Is there a formula here to replace sequencially all characters of a given value by a specific character?

Let me show you.

I have this value : google.com

need to replace one character after one character by the "*" symbol. So it will give me this :

*oogle.com
g*ogle.com
go*gle.com
goo*le.com
goog*e.com
googl*.com
google*com
google.*om
google.c*m
google.co*

Should work with any number of characters. Will use it maintly for domains, so it could be .com, .net, .me, .info, etc....

Thanks for the help.

 

[ukmikeb]

Hi

Try :-

=IF(ROWS($A$1:$A2)-1>LEN($A$1),"",REPLACE($A$1,ROWS($A$1:$A2)-1,1,"*"))

hth

 

[ukmikeb]

Hi

Sorry, I meant to qualify that the formula should be entered in A2 and dragged down.

 

[mlektra]

Thanks! it worked

But what if I have 3 columns (H-I-J) (that are output of formulas) and I want to take the output of these 3 columns and group them (in order) in one column only (K)?

 

[ukmikeb]

Hi

The easiest way to do that is to copy each column sequentially into Column K by PasteValues then do a sort.

The alternative would be a complex formula, especially if each column has a different number of items.

hth