| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I separate a hyphenated word in Excel?
I have a large file of 2000 lines and I would like to make 2 columns from 1.
For example: COLUMN A HEW-FA282A I would like to remove the HEW- and insert it into another (new) column and have the original column just read FA282A. Since the word is hyphenated I have been unable to find the appropriate formula. Can anyone help me? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cannot establish a DDE with WORD | Excel Discussion (Misc queries) | |||
| Merging in Excel from Word, Excel, or Access | Excel Discussion (Misc queries) | |||
| Opening two separate instances of Excel | Excel Discussion (Misc queries) | |||
| Pasting Word table cell with paragraph markers into single Excel c | Excel Discussion (Misc queries) | |||
| Can Excel Export Data to Word Format? | Excel Discussion (Misc queries) | |||
Threaded Mode
