parsing a cell using |

[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.

 

[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

 

[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
(e-mail address removed)

 

[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.

 

[Nick Hodge]

RD

Of course...you'll notice I like re-inventing a wheel from time to time ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)