Rick's method:Originally Posted by jamilm
The countif is counting if there are a number of spaces as far as I can tell.
Rick's method works with max 3 words - more than 3 words, it fails to reverse proper
Looks like a simpler version than mine, however, mine works with more than 3 names (or 2 spaces).
My method is:
=MID(MASTER!B5&", "&MASTER!B5,FIND("^^",SUBSTITUTE(MASTER!B5," ","^^",LEN(MASTER!B5)-LEN(SUBSTITUTE(MASTER!B5," ",""))))+1,LEN(MASTER!B5)+1)
B5 is the single sell with format of:
"First Last"
"First Middle Last"
"First Middle1 Middle2 Last"
note: format for Rick's or my versions MUST have at least one space, ie: 2 words
It may be complicated, but gets the job done, and the only way I could get it to work proper.
As for explaining code, the best way to learn is to dissect it yourself, and learn how each function works. That is mainly how I learned programming, computers, driving, drinking and you can guess the rest.
Reply With Quote
Bookmarks