How do i do this, please help

[facebuddies]

Hi

How can i do this

I have various emails (Test ones ) below

mykiakel@yahoo.com:pinkie2 snow_713@hotmail.com:nomodramqa1 dancer1o4@hotmail.com:d4/12/01 ladytwalden@yahoo.com:ladyt84 jidge34@yahoo.com:francois1 k.shaw2smooth@yahoo.com:HAWAII92 partypimpin99@yahoo.net:bermuda1. starmaniac_10@hotmail.com:rogelio1 well_thats_right_i_may_have_faked_it@hotmail.com:colthall. partypimpin99@yahoo.net:bermuda1. er1923strawberries_n_cream19@hotmail.com:wheel tryn2comeup@yahoo.com:jude tryn2comeup@yahoo.com:jude

I need the email address and the wording after the : to be on one line like this

mykiakel@yahoo.com:pinkie2
snow_713@hotmail.com:nomodramqa1

etc etc

There is a space after the last letter and the next letter to separate these

Can any one do this

[colofnature]

Select the cell, go to the Data menu, select "Text to columns...". Choose "delimited", click Next, check the box next to "Space" then click "Finish", this will separate the data at each space. Highlight the now-separate emails, copy them then select A2 and choose "Paste Special" from the Edit menu. Check the "Transpose" box near the bottom, then click OK.

Col

[facebuddies]

Thanks col once again

:-)

[facebuddies]

Hi

using that method excel only lets me do 256 lines, is there anyway that i can let it add more than this

:-)

[colofnature]

Please Login or Register  to view this content.

C

[facebuddies]

Where do i enter this, i thought maybe it is a macro , i really do not know!!

Can i have a step by step guide please at all

:-)

[facebuddies]

Hurray i worked it out lol

:-)