software

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: www.excelforum.com/member.php...oamp;userid=31338
View this thread: www.excelforum.com/showthread...hreadid=516042If 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.

PeteI would highlight the data and use Datagt;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

=A1amp;quot;|quot;amp;B1amp;quot;|quot;amp;C1...etc

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HISquot;exceluser2quot; gt; wrote
in message ...
gt;
gt; I have many cells with values like this
gt;
gt; 43543|F|ib315|RAS|98B8016BB4B12|stamp
gt;
gt; I need to parse each cell using | and place the parsed values into new
gt; cells for each row while still maintaing the unparsed cell. Any help
gt; is appreciated.
gt;
gt;
gt; --
gt; exceluser2
gt; ------------------------------------------------------------------------
gt; exceluser2's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31338
gt; View this thread: www.excelforum.com/showthread...hreadid=516042
gt;
There's really *no* need to quot;put the original back togetherquot;, 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 !
---------------------------------------------------------------------------

quot;Nick Hodgequot; gt; wrote in message
...
gt; I would highlight the data and use Datagt;Text to columns... and use the |
gt; character as the 'other' delimiter. Then when you have parsed it all, use
a
gt; helper column to put the original back together with
gt;
gt; =A1amp;quot;|quot;amp;B1amp;quot;|quot;amp;C1...etc
gt;
gt; --
gt; HTH
gt; Nick Hodge
gt; Microsoft MVP - Excel
gt; Southampton, England
gt; www.nickhodge.co.uk
gt; HIS
gt;
gt;
gt; quot;exceluser2quot; gt;
wrote
gt; in message ...
gt; gt;
gt; gt; I have many cells with values like this
gt; gt;
gt; gt; 43543|F|ib315|RAS|98B8016BB4B12|stamp
gt; gt;
gt; gt; I need to parse each cell using | and place the parsed values into new
gt; gt; cells for each row while still maintaing the unparsed cell. Any help
gt; gt; is appreciated.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; exceluser2
gt; gt; ------------------------------------------------------------------------
gt; gt; exceluser2's Profile:
gt; gt; www.excelforum.com/member.php...oamp;userid=31338
gt; gt; View this thread:
www.excelforum.com/showthread...hreadid=516042
gt; gt;
gt;
gt;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
HISquot;RagDyerquot; gt; wrote in message
...
gt; There's really *no* need to quot;put the original back togetherquot;, since TTC
gt; has
gt; an option to separate the data *without* touching (changing) the original
gt; data.
gt;
gt; In the 3rd step of the TTC wizard, just change the destination column
gt; address from the default (original data location) to any *other* empty
gt; column.
gt; --
gt; Regards,
gt;
gt; RD
gt;
gt; ---------------------------------------------------------------------------
gt; Please keep all correspondence within the NewsGroup, so all may benefit !
gt; ---------------------------------------------------------------------------
gt;
gt; quot;Nick Hodgequot; gt; wrote in message
gt; ...
gt;gt; I would highlight the data and use Datagt;Text to columns... and use the |
gt;gt; character as the 'other' delimiter. Then when you have parsed it all,
gt;gt; use
gt; a
gt;gt; helper column to put the original back together with
gt;gt;
gt;gt; =A1amp;quot;|quot;amp;B1amp;quot;|quot;amp;C1...etc
gt;gt;
gt;gt; --
gt;gt; HTH
gt;gt; Nick Hodge
gt;gt; Microsoft MVP - Excel
gt;gt; Southampton, England
gt;gt; www.nickhodge.co.uk
gt;gt; HIS
gt;gt;
gt;gt;
gt;gt; quot;exceluser2quot; gt;
gt; wrote
gt;gt; in message
gt;gt; ...
gt;gt; gt;
gt;gt; gt; I have many cells with values like this
gt;gt; gt;
gt;gt; gt; 43543|F|ib315|RAS|98B8016BB4B12|stamp
gt;gt; gt;
gt;gt; gt; I need to parse each cell using | and place the parsed values into new
gt;gt; gt; cells for each row while still maintaing the unparsed cell. Any help
gt;gt; gt; is appreciated.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; --
gt;gt; gt; exceluser2
gt;gt; gt; ------------------------------------------------------------------------
gt;gt; gt; exceluser2's Profile:
gt;gt; gt; www.excelforum.com/member.php...oamp;userid=31338
gt;gt; gt; View this thread:
gt; www.excelforum.com/showthread...hreadid=516042
gt;gt; gt;
gt;gt;
gt;gt;
gt;