How to Split data in phone directories

Closed
JJ - 3 Jan 2012 à 04:05
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 3 Jan 2012 à 21:04
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 response

venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
3 Jan 2012 à 21:04
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.