Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to seperate 2 values to 2 different cells
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: http://www.excelforum.com/member.php...fo&userid=6156 View this thread: http://www.excelforum.com/showthread...hreadid=536917 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to seperate 2 values to 2 different cells
Highlight the data range,
Under the Data menu choose "Text to Columns", Keep Delimited as the choice on the first screen, hit "Next" put a "+" in the box to the right of "Other" and hit "Finish". Bill "nander" wrote: 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: http://www.excelforum.com/member.php...fo&userid=6156 View this thread: http://www.excelforum.com/showthread...hreadid=536917 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to seperate 2 values to 2 different cells
nander
Make sure there is an empty column to right of the cells. Select all cells. DataText to ColumnsDelimited byOther. Enter the + sign and finish. Gord Dibben MS Excel MVP On Thu, 27 Apr 2006 12:45:41 -0500, nander wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sum up values only in cells that are color filled? | Excel Worksheet Functions | |||
How do I sum the absolute values of a range of cells? | Excel Discussion (Misc queries) | |||
paste special | values should work with merged cells | Excel Discussion (Misc queries) | |||
How To Use Cells Without Values in a Formula | Excel Worksheet Functions | |||
Help adding text values | Excel Worksheet Functions |