software

In the examples below these values are in column B. I'd like the values
beyond the sigh to move to the next cell. So B only contains
CA*F060*2* AND C contains G*V80905C

B
1 CA*F060*2* G*V80905C**
2 CA*F060*2* G*V81155C**
3 CA*F060*2* G*V90905D**
4 CA*F060*2* G*V950905D**
5 CA*F060*2* G*V951155D**
6 CA*F060*2* MBE1600--
nander
------------------------------------------------------------------------
nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
View this thread: www.excelforum.com/showthread...hreadid=536917Highlight the data range,
Under the Data menu choose quot;Text to Columnsquot;,
Keep Delimited as the choice on the first screen, hit quot;Nextquot;
put a quot; quot; in the box to the right of quot;Otherquot; and hit quot;Finishquot;.

Bill

quot;nanderquot; wrote:

gt;
gt; In the examples below these values are in column B. I'd like the values
gt; beyond the sigh to move to the next cell. So B only contains
gt; CA*F060*2* AND C contains G*V80905C
gt;
gt; B
gt; 1 CA*F060*2* G*V80905C**
gt; 2 CA*F060*2* G*V81155C**
gt; 3 CA*F060*2* G*V90905D**
gt; 4 CA*F060*2* G*V950905D**
gt; 5 CA*F060*2* G*V951155D**
gt; 6 CA*F060*2* MBE1600
gt;
gt;
gt; --
gt; nander
gt; ------------------------------------------------------------------------
gt; nander's Profile: www.excelforum.com/member.php...foamp;userid=6156
gt; View this thread: www.excelforum.com/showthread...hreadid=536917
gt;
gt;

nander

Make sure there is an empty column to right of the cells.

Select all cells.

Datagt;Text to Columnsgt;Delimited bygt;Other. Enter the sign and finish.Gord Dibben MS Excel MVP

On Thu, 27 Apr 2006 12:45:41 -0500, nander
gt; wrote:

gt;
gt;In the examples below these values are in column B. I'd like the values
gt;beyond the sigh to move to the next cell. So B only contains
gt;CA*F060*2* AND C contains G*V80905C
gt;
gt;B
gt;1 CA*F060*2* G*V80905C**
gt;2 CA*F060*2* G*V81155C**
gt;3 CA*F060*2* G*V90905D**
gt;4 CA*F060*2* G*V950905D**
gt;5 CA*F060*2* G*V951155D**
gt;6 CA*F060*2* MBE1600