If there are no spaces, we will have to check to see if the last letter is
capitalized or lower case. Check back tomorrow.
--
Gary''s Student - gsnu200777


"Max Pressure" wrote:

Thanks GS, that works if there are spaces, but no spaces. Got a modification
for no spaces?

Thanks!
-Max

"Gary''s Student" wrote:

Here is a tiny trick to help reduce the pressure on you. Suppose column A
contains data like:

J Ravenswood
Ravenswood J

In C1 enter:
=IF(FIND(" ",A1,1)=2,A1,RIGHT(A1,1) & " " & LEFT(A1,LEN(A1)-2))
and copy down. This will convert all the names into
<initial<space<lastname

Then use any VLOOKUP() on columns B & C


--
Gary''s Student - gsnu200777


"Max Pressure" wrote:

Hi,
Here's what I've got:
Column A has 400 usernames in 2 different formats:
<lastname<firstinitial and <firstinitial<lastname
(and yeah, they're all mixed up)

Column B Has all these users listed by last name

I'm trying to reconcile Column B against Column A. I have some experience
with the vLookup function but I don't know how to make this scenario work.

Any assistance would be greatly appreciated!
-Max