Seperate data in one field into relevant multiple Fields

[Peter Thompson]

Please can any assist with an excel sheet in which
data is contained within one field. i.e name, address
postcode all appear within column A

Each data set within the single column is separated by
an embedded carriage return.

I have attempted to no avail to replace this character
with a comma to then re-import into excel as a csv
file with respective data columns.

Your assistance would be most appreciated.


Charlotte Thompson

 

[Frank Kabel]

Hi
try in Excel suing 'Data - Text to columns' for this

 

[RagDyer]

If you had trouble using "Edit - Replace", you'll probably also have the
same trouble using "TextToColumns".

It comes down to what character you're entering as the "FindWhat" character
in Edit&Replace, and what character you would use as the "Delimiter" in TTC.

If you used <Alt> <Enter> to create your line breaks, then that should be
CHAR(10).

So, if you used "Edit - Replace", in the "FindWhat" box you could enter:
<ENTER>
OR
Hold down <Alt>, and type
0010
Using the num keypad, *not* the numbers under the function keys.
In both cases, *nothing* will be visible in the "FindWhat" box.
Just click in the "ReplaceWith" box and enter your comma.

In TTC, you *cannot* hit the <Enter> key to define the delimiter in the
"other" box, you must use the <Alt> 0010 method to specify the "hard line
break" as your delimiter.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hi
try in Excel suing 'Data - Text to columns' for this

 

[Peter Thompson]

Thank you for your assistance !

Charlotte