Convert from one Column using if function

Closed
ssoumitra Posts 3 Registration date Thursday October 23, 2014 Status Member Last seen October 24, 2014 - Oct 23, 2014 at 03:14 PM
ssoumitra Posts 3 Registration date Thursday October 23, 2014 Status Member Last seen October 24, 2014 - Oct 24, 2014 at 01:22 AM
hi i have the information in one Column "A".

This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but each address starts with "To,". so

I want to get those 100 address in 100 rows.

Thank you for your time.

2 replies

davidkalav Posts 6 Registration date Thursday October 23, 2014 Status Member Last seen October 23, 2014
Oct 23, 2014 at 08:07 PM
Ok
0
ssoumitra Posts 3 Registration date Thursday October 23, 2014 Status Member Last seen October 24, 2014
Oct 24, 2014 at 01:20 AM
Ha ha thanks David
0
ssoumitra Posts 3 Registration date Thursday October 23, 2014 Status Member Last seen October 24, 2014
Oct 24, 2014 at 01:22 AM
hi i have the information in one Column "A".



This "A"Column contains 100 address .(Each line of the address has been typed in separate row) but each address starts with "To,". so



I want to get those 100 address in 100 rows.


Can some one help me with this .
Thank you for your time.
0