I get a daily email regarding employee terminations (always in the same format). What I would like to do is reference a unique ID# to use a vlookup to check if they have a certain asset in "list1", and if they do, use Outlook to email their manager (also contained in term list) and fill in a...
Thanks everyone,
I took some advice off Bluedragon's post and used the Left and Right commands while modifying the use of Find with the commas. Kind of a roundabout compared to some other solutions, but It's working for me. Thanks alot.
Thanks Blue, got closer, but still not getting a usable output...
The formula worked on a few, but not that many.
Example
Jim,Wilson became Wilson,Jim,W
Any way to fix this??
Thanks in advance
If I have cells with input "FirstName,LastName" in the same cell, what is the best way to manipulate the text into a new cell with the input being "LastName,FirstName"? If possible, I would like to do this without using macros. Any ideas?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.