Convert from one Column using if function [Closed]

Report
Posts
3
Registration date
Thursday October 23, 2014
Status
Member
Last seen
October 24, 2014
-
Posts
3
Registration date
Thursday October 23, 2014
Status
Member
Last seen
October 24, 2014
-
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

Posts
6
Registration date
Thursday October 23, 2014
Status
Member
Last seen
October 23, 2014

Ok
Posts
3
Registration date
Thursday October 23, 2014
Status
Member
Last seen
October 24, 2014

Ha ha thanks David
Posts
3
Registration date
Thursday October 23, 2014
Status
Member
Last seen
October 24, 2014

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!