How to Split data in phone directories

Closed
JJ - Jan 3, 2012 at 04:05 AM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Jan 3, 2012 at 09:04 PM
Hello,

Kindly advise how should i have the raw data below being seperated to format required?

The raw datas are as below:-
Zexcom Sdn Bhd
8A Jin Pp 2/2 Puchong 1234
Zextron Chemical Industries (M) Sdn Bhd
4 Jin Injap 34/4 SAIam 5567
Zey Sportbike Enterprise
20G Jin Semenyih Sentral 2
Semenyih 1124

To:-
Name Address Tel
Zexcom Sdn Bhd 8A Jin Pp 2/2 Puchong 1234
Zextron Chemical Industries (M) Sdn Bhd ] 4 Jin Injap 34/4 5567
SAIam
Zey Sportbike Enterprise 20G Jin Semenyih Sentral 2 Semenyih

Your time spent are very much highly appreciated. Thank you so much.


1 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Jan 3, 2012 at 09:04 PM
you have not clarified whether the whole basic data is in one column.
if so use date(menu)-text to columns-fixed column width. this may help you.


If it is more complicated a macro is required.
0