| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting All But Last Word
I work with street addresses and want to make changes to the suffixes
without changing the rest of the address. I know how to use a function to copy the suffix (or last word in a cell) to another cell. But, I do not know how to copy everything EXCEPT the suffix (or last word in a cell) to another cell. Please suggest a formula that will do this. TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking table in Excel to word | Links and Linking in Excel | |||
| Print Excel charts in Word 2003 with fixed size | Charts and Charting in Excel | |||
| Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Embedded word doc changed to image-need to change back to word. | Excel Discussion (Misc queries) | |||
Threaded Mode
