Hi Beh,
This might be a bit shorter. See which you like better (the one that works!)
![]()
=TRIM(SUBSTITUTE(MID(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",20)),40,20)),4,3),"@",""))
Hi Beh,
This might be a bit shorter. See which you like better (the one that works!)
![]()
=TRIM(SUBSTITUTE(MID(TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",20)),40,20)),4,3),"@",""))
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks