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!
|