extremedownline
New Member
- Joined
- Apr 1, 2013
- Messages
- 2
Hi,
I having the following cells in my excel sheet:
Address1 Address2
<tbody>
</tbody>
I would like to extract all unit number from Address 1 eg. #02-03A to Address 2 . End product should look like this:
Address1 Address2
<tbody>
</tbody>
Appreciate someone could help me out... Thanks!!!
I having the following cells in my excel sheet:
Address1 Address2
1 COLEMAN STREET #02-03A | THE ADELPHI |
15 BEACH ROAD, #03-051 | BEACH CENTRE, SINGAPORE |
5001 BEACH RD #09-02 | GOLDEN MILE COMPLEX |
5001 BEACH ROAD #02-342 | GOLDEN MILE COMPLEX |
6001 BEACH ROAD #16-56 | GOLDEN MILE TOWER |
<tbody>
</tbody>
I would like to extract all unit number from Address 1 eg. #02-03A to Address 2 . End product should look like this:
Address1 Address2
1 COLEMAN STREET | #02-03A THE ADELPHI |
15 BEACH ROAD, | #03-051 BEACH CENTRE, SINGAPORE |
5001 BEACH RD | #09-02 GOLDEN MILE COMPLEX |
5001 BEACH ROAD | #02-342 GOLDEN MILE COMPLEX |
6001 BEACH ROAD | #16-56 GOLDEN MILE TOWER |
<tbody>
</tbody>
Appreciate someone could help me out... Thanks!!!