[hcs-d] Excel Text to Columns Issue

[Jon Staff]

Hi team hcs,

In my excel database I have a column of cells that contain full  =

addresses, with the address, city and country seperated by enter, but  =

contained in one cell, such as:

Librairie Descours 31 rue Auguste Comte
Lyon 69002
France
I am trying to do text to columns to split off the name of the  =

country only -- in this case France.  However, no matter what way I  =

set text to columns, it will only do the first line... so at best, I  =

can split it into, in this case:

Librarie   |    Descours    |  31  |   rue  |  Auguste   |  Comte


Or some variation thereof, but the second two lines of the address  =

don't reappear.


I have tried replacing all the country names with various symbols +  =

the country name ";France" or "=A2France" and tried to delimit by that  =

symbol, but still, no luck.

Any ideas?

Thanks so much,

--Jon





-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.hcs.harvard.edu/pipermail/hcs-discuss/attachments/2009042=
6/2eec1065/attachment.htm