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
HIS


"RagDyer" wrote in message
...
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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nick Hodge" wrote in message
...
I would highlight the data and use DataText 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
HIS


"exceluser2"
wrote
in message
...

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.


--
exceluser2
------------------------------------------------------------------------
exceluser2's Profile:
http://www.excelforum.com/member.php...o&userid=31338
View this thread:
http://www.excelforum.com/showthread...hreadid=516042