G gsrajan Registered User. Local time Today, 17:42 Joined Apr 22, 2014 Messages 227 May 13, 2014 #1 Hi, I have a table imported from excel, in which both First and Last names are in upper cases. Is there a way to change the First names into proper case?. Thank you.
Hi, I have a table imported from excel, in which both First and Last names are in upper cases. Is there a way to change the First names into proper case?. Thank you.
pr2-eugin Super Moderator Local time Today, 22:42 Joined Nov 30, 2011 Messages 8,494 May 13, 2014 #2 StrConv is a function in VBA, which has an argument vbProperCase. Code: ? StrConv("PAUL eUgIn FrAnCiS", vbProperCase) Paul Eugin Francis
StrConv is a function in VBA, which has an argument vbProperCase. Code: ? StrConv("PAUL eUgIn FrAnCiS", vbProperCase) Paul Eugin Francis
G gsrajan Registered User. Local time Today, 17:42 Joined Apr 22, 2014 Messages 227 May 13, 2014 #3 Thank you.
