Posted to microsoft.public.excel.worksheet.functions
|
|
Extract specific text
"Rick Rothstein (MVP - VB)" wrote...
....
Here is a slightly shorter formula . . .
....
=MID(A1,2+FIND(", ",A1),FIND(" ",A1,2+FIND(", ",A1))-2
-FIND(", ",A1))&MID(A1,FIND(" ",A1,1+FIND(" ",A1)),FIND(", ",A1)
-FIND(" ",A1,1+FIND(" ",A1)))
It won't be shorter when you wrap each A1 reference inside TRIM. Safer to
use TRIM(A1) than just A1.
|