MandyCandy
New Member
- Joined
- Oct 1, 2015
- Messages
- 7
Hi Everyone,
First time poster, hope I am following all the rules. My dilemma right now is:
I have an excel with around 3000 office addresses all in a single column, I need to split this in two (i:e, Address becomes, Address 1 and Address 2) For EG:
<tbody>
</tbody>
As you can see, one issue I have is that some of the 3000 are typed out manually and with Line-Break. I have used a "=clean(substitute" formula to deal with this problem.
My Second issue is that some of the addresses are with Line-Break and without Commas, hence when I used the Clean Formula the words have gotten attached, so using a (Text-to-column- Delimited) is not working completely either.
I am using an excel 2007, and have access to 2010, My deadline for submission is in 24 hours. Praying someone here can help me out.
First time poster, hope I am following all the rules. My dilemma right now is:
I have an excel with around 3000 office addresses all in a single column, I need to split this in two (i:e, Address becomes, Address 1 and Address 2) For EG:
Address | Address 1 | Address 2 |
#203/205, ground floor, Bellendur, Outer Ring Road, Bangalore - 560 103 | #203/205, ground floor, Bellendur, | Outer Ring Road, Bangalore - 560 103 |
<tbody>
</tbody>
As you can see, one issue I have is that some of the 3000 are typed out manually and with Line-Break. I have used a "=clean(substitute" formula to deal with this problem.
My Second issue is that some of the addresses are with Line-Break and without Commas, hence when I used the Clean Formula the words have gotten attached, so using a (Text-to-column- Delimited) is not working completely either.
I am using an excel 2007, and have access to 2010, My deadline for submission is in 24 hours. Praying someone here can help me out.