| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extract the first word from a cell?
I'm using Excel 2003 and need to return the first eight characters from a cell.
The "Left" function is fine for this but where the first word is less than eight characters I only want to extract the first word and "left" includes the start of the second word! Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I use word wrap in a merged cell in excel 2000? | Excel Discussion (Misc queries) | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| Copy Word table into Excel cell by cell | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
| vlookup to extract part cell content | Excel Discussion (Misc queries) | |||
Threaded Mode
