is this possible to do in excel?

[reality]

Hi,

I need your help here with something. Thank you in advance for your advice. (tried searching the forum)

say i need to format a bunch of urls into different format how do i do it? Here's an example,

say i copy a bunch of domains...
domain.com
domain.com
domain.com
domain.com

and paste it into excel....i want excel to auto format the above into...

domain com (without the dot and a space)
www domain (without .com and add www and space in front)
www.domain.com
do main com

Is the above possible? I am a total newbie in this and I dont even know where to start searching for this solution. Because i need this ASAP I dun have the time to go thru the whole book.

Please advice, i am very willing to learn. Thank you.

Ryan

 

[Mike Blackman]

HI,

Using simple formula you can use;

=SUBSTITUTE(A1,"."," ")

to get element 1, and;

="www "&SUBSTITUTE(A1,".com","")

to get element 2.

Hope this helps.

 

[reality]

HI,

Using simple formula you can use;

=SUBSTITUTE(A1,"."," ")

to get element 1, and;

="www "&SUBSTITUTE(A1,".com","")

to get element 2.

Hope this helps.

I think it will really work, if i want to learn this further under what chapter name or type is this under?

I will try this out now and report back. Thanks for your help

Ryan

 

[reality]

I just tested it and it works! I have a few other variations but i figured everything out using what you gave me. THANK YOU!

I can't figure out how to make one variations work that is from mrexcel.com to mr excel com because every URL is different so there's no way to make this work but thats ok. you saved me 90% of the time i need to get this done.

 

[Mike Blackman]

Hi Ryan,

If you have a lot of URL's for Mr Excel you could use this for them;

=LEFT(A1,2)&" "&MID(A1,3,5)&" "&RIGHT(A1,3)

If they are jumbled in with othere;

=IF(A1="mrexcel.com","Mr Excel Com",A1)

Or you could embed the first formula within the IF statement;

=IF(A1="mrexcel.com",LEFT(A1,2)&" "&MID(A1,3,5)&" "&RIGHT(A1,3),"")

Hopefully this will give you a few more idea's.