parsing a cell using |

E

exceluser2

I have many cells with values like this

43543|F|ib315|RAS|98B8016BB4B12|stamp

I need to parse each cell using | and place the parsed values into new
cells for each row while still maintaing the unparsed cell. Any help
is appreciated.
 
P

Pete_UK

If these are in column A, then copy this to column B to retain the
original data. Then highlight column B and do Data | Text-to-columns
and specify | as the delimiter.

Hope this helps.

Pete
 
N

Nick Hodge

I would highlight the data and use Data>Text to columns... and use the |
character as the 'other' delimiter. Then when you have parsed it all, use a
helper column to put the original back together with

=A1&"|"&B1&"|"&C1...etc

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
 
R

RagDyer

There's really *no* need to "put the original back together", since TTC has
an option to separate the data *without* touching (changing) the original
data.

In the 3rd step of the TTC wizard, just change the destination column
address from the default (original data location) to any *other* empty
column.
 
Top