| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Splitting Data in a cell, left or right of a separator.
I need to split some data in a cell to the right of a separator, which is a
colon. eg: "CONSUMABLE:HPC92298X" Would someone be able to point me in the right direction.. many thanks, Ross |
|
#2
|
|||
|
|||
|
One way is to use Data Text to Columns
Select the column Click Data Text to columns (Delimited) Click Next In step 2: Type a colon in the "Other:" box Click Finish -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "ross" wrote in message ... I need to split some data in a cell to the right of a separator, which is a colon. eg: "CONSUMABLE:HPC92298X" Would someone be able to point me in the right direction.. many thanks, Ross |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Creating a cell so data goes into a table | Excel Discussion (Misc queries) | |||
| Refering to a tab using data from a cell | Excel Worksheet Functions | |||
| Add data to cell w/o loosing initial data | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
