Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get section of text from cell
Hey,
A long row of cells contains a item number and a item name, something like this: 123456, item name I only need the item number as a result. Is there a way to extract only the text in front of a seperation mark (in this case the , )? Note, the item number can contain numbers and/or letters and a interspace. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Wrap text in header section Excel 2007 | Excel Discussion (Misc queries) | |||
how do I highlight section in cell | Excel Discussion (Misc queries) | |||
How do I print just the section a through f only? | New Users to Excel | |||
Converting selected section of text to numbers | Excel Discussion (Misc queries) | |||
Stripping section of text | Excel Worksheet Functions |