i am using this formula to flip first and last name, remove the comma, and also remove (NonEmp) (hence the -8 bolded in the second FIND function.Please Login or Register to view this content.
So if Jones, Jack R (NonEmp) were in A13, it would show like this Jack R Jones (NonEmp)
or Jones, John would show simply as John Jones
The problem is, I want to plan ahead and have it remove the Parenthesis and it's contents regardless of length. So if it is entered (Non Emp) it will still remove.
I tried this to no avail... Bolded is what changed.
any suggestions?Please Login or Register to view this content.
Bookmarks