Hi,
I am trying to find a way to capitalize the last word in a cell. I frequently get
names formatted where A1 = First Name A2 = Last name or A1=jan A2=van der hass and need to capitalize the h in hass. I have not been able to find a way to accomplish this. Your help is greatly appreciated.