S
swattoo
Dear All,
I have data in the following format (One Column With All the Data. Eac
Row Contains Different Data as mentioned below):
See Attachments for This
360-Lifestyle (Specialized)
P.O.Box71813
Tel04-3383310
LocationNext to BMW Show Room, Sh Zayed Road, Dubai
Send Enquiry
Abdul Majeed Bicycle
P.O.Box9586
Tel02-5542517
LocationM 6, Mussafah, Abu Dhabi
Send Enquiry
Abdulla Bilal Bilal Bicycle Trading
P.O.Box23978
Tel04-3497118
LocationAl Dhiyafa Road, Satwa, Dubai
Send Enquiry
and I need this data in below mentioned format
360-Lifestyle (Specialized) 71813 +9714-3383310 Next to BMW Show Room
Sh Zayed Road, Dubai Send Enquiry
Abdul Majeed Bicycle 9586 +9712-5542517 M 6, Mussafah, Abu Dhabi Sen
Enquiry
Abdulla Bilal Bilal Bicycle Trading 23978 +9714-3497118 Al Dhiyaf
Road, Satwa, Dubai Send Enquir
+-------------------------------------------------------------------
|Filename: Data Available.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=613
|Filename: Required Format.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=614
+-------------------------------------------------------------------
I have data in the following format (One Column With All the Data. Eac
Row Contains Different Data as mentioned below):
See Attachments for This
360-Lifestyle (Specialized)
P.O.Box71813
Tel04-3383310
LocationNext to BMW Show Room, Sh Zayed Road, Dubai
Send Enquiry
Abdul Majeed Bicycle
P.O.Box9586
Tel02-5542517
LocationM 6, Mussafah, Abu Dhabi
Send Enquiry
Abdulla Bilal Bilal Bicycle Trading
P.O.Box23978
Tel04-3497118
LocationAl Dhiyafa Road, Satwa, Dubai
Send Enquiry
and I need this data in below mentioned format
360-Lifestyle (Specialized) 71813 +9714-3383310 Next to BMW Show Room
Sh Zayed Road, Dubai Send Enquiry
Abdul Majeed Bicycle 9586 +9712-5542517 M 6, Mussafah, Abu Dhabi Sen
Enquiry
Abdulla Bilal Bilal Bicycle Trading 23978 +9714-3497118 Al Dhiyaf
Road, Satwa, Dubai Send Enquir
+-------------------------------------------------------------------
|Filename: Data Available.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=613
|Filename: Required Format.JPG
|Download: http://www.excelbanter.com/attachment.php?attachmentid=614
+-------------------------------------------------------------------