View Single Post
 
Old 09-06-2011, 09:20 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Quote:
the above code shows PETER,RAJ
BUT IN SHEET 2 shows PETER, RAJ
Code:
strEmployeeBothName = strEmpLName & ", "& strEmpFName
sorry, but the above code shows PETER, RAJ not PETER,RAJ as you say (look at the line 7 in your posted code)
at this row in your code, it says : put between the last name and first name a comma and a space... if you don't want a space between names, just delete the space after the comma...
and you can change in your code the lower case to upper case to match the format in the other sheet...
How do you want to use the results of this comparison?
(maybe if you upload a sample with data and desired results, will ease communication...)
Reply With Quote