Convert from one Column using if function

Closed
ssoumitra Posts 3 Registration date Thursday 23 October 2014 Status Member Last seen 24 October 2014 - 23 Oct 2014 à 15:14
ssoumitra Posts 3 Registration date Thursday 23 October 2014 Status Member Last seen 24 October 2014 - 24 Oct 2014 à 01:22
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.
Related:

2 responses

davidkalav Posts 6 Registration date Thursday 23 October 2014 Status Member Last seen 23 October 2014
23 Oct 2014 à 20:07
Ok
ssoumitra Posts 3 Registration date Thursday 23 October 2014 Status Member Last seen 24 October 2014
24 Oct 2014 à 01:20
Ha ha thanks David
ssoumitra Posts 3 Registration date Thursday 23 October 2014 Status Member Last seen 24 October 2014
24 Oct 2014 à 01:22
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.