software

I need to convert data in an excel file from:

Brimelows Shop 2 15 Howey Pl MELBOURNE VIC 3000 (03) 9671 3733
Bungendore Leather amp; Ginninderra Leather Ginninderra Vlge Gold Creek
NICHOLLS ACT 2913 (02) 6230 2770

to:
Brimelows // Shop 2 15 Howey Pl // MELBOURNE // VIC // 3000 // (03) 9671
3733
Bungendore Leather amp; Ginninderra Leather // Ginninderra Vlge Gold Creek //
NICHOLLS // ACT // 2913 // (02) 6230 2770
where quot;//quot; are seperate columns.

ie convert A1 (Brimelows Shop 2 15 Howey Pl MELBOURNE VIC 3000 (03) 9671
3733) to
B1 Brimelows
C1 Shop 2 15
D1 Howey Pl
E1 MELBOURNE
F1 VIC
G1 3000
H1 (03) 9671 3733

The positioning of the data varies, A1 is different to B1 as per above just
to make it more difficult.

Can someone help please.

Pls reply to NG or email to petersmith37AThtmailDOTTcomm

pls replace server name to hotmail.com

Thanks in advance
Pete
I suggest you look at using a combination of:

1) Search and replace with wildcards to get your text in a more regular form.

2) Data-gt;Text to Columns

Regards: Colin

quot;Aaaaaquot; wrote:

gt; I need to convert data in an excel file from:
gt;
gt; Brimelows Shop 2 15 Howey Pl MELBOURNE VIC 3000 (03) 9671 3733
gt; Bungendore Leather amp; Ginninderra Leather Ginninderra Vlge Gold Creek
gt; NICHOLLS ACT 2913 (02) 6230 2770
gt;
gt; to:
gt; Brimelows // Shop 2 15 Howey Pl // MELBOURNE // VIC // 3000 // (03) 9671
gt; 3733
gt; Bungendore Leather amp; Ginninderra Leather // Ginninderra Vlge Gold Creek //
gt; NICHOLLS // ACT // 2913 // (02) 6230 2770
gt; where quot;//quot; are seperate columns.
gt;
gt; ie convert A1 (Brimelows Shop 2 15 Howey Pl MELBOURNE VIC 3000 (03) 9671
gt; 3733) to
gt; B1 Brimelows
gt; C1 Shop 2 15
gt; D1 Howey Pl
gt; E1 MELBOURNE
gt; F1 VIC
gt; G1 3000
gt; H1 (03) 9671 3733
gt;
gt; The positioning of the data varies, A1 is different to B1 as per above just
gt; to make it more difficult.
gt;
gt; Can someone help please.
gt;
gt; Pls reply to NG or email to petersmith37AThtmailDOTTcomm
gt;
gt; pls replace server name to hotmail.com
gt;
gt; Thanks in advance
gt; Pete
gt;
gt;
gt;