| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
delete middle word from a cell
Good morning
I have a large spreadsheet. The entry in one columns has a name e.g. Mr. John Smith. what I need is to delete the middle name so that it reads Mr. Smith I tried the functions LEFT , RIGHT, and text to columns. what is the right way to do this or do I need a macro? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy text from word with returns into one cell | Excel Discussion (Misc queries) | |||
| copy excel cell to cell in word table using excel macro | Excel Discussion (Misc queries) | |||
| Delete all contents of cell but one word | Excel Discussion (Misc queries) | |||
| How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
