| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Mid and Find in macro
Hi!
I'm trying to use this type of formula in a macro, but I can't figure out the syntax: Trim(MID(A1,FIND(" ",A1),255)) So if I have "Alpha Dog" in a cell, I want to only show "Dog". The length of each word or number will vary and there could be multiple spaces between them. Appreciate any help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro that does a find and then find next | Excel Programming | |||
| Find & Replace and Find & Insert macro help needed | Excel Programming | |||
| Get Macro warning, but can't find Macro | Excel Worksheet Functions | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| I need to find a macro to find data cut and paste to another colu. | Excel Programming | |||
Threaded Mode
