B
Bill D
Hi,
I've acquired a huge Excel (2002) file which I'd like to use in a mailmerge
but unfortunately all text entered previously is in uppercase. I've found
the function Proper() which corrects uppercase to first letter as a capital
then the rest as lowercase, but.... it appears that it can only be used to
convert individual cells into a new/adjacent cell (i.e not simply convert
the existing cell.
Can anyone help me overcome this problem please?
Cheers
Bill
I've acquired a huge Excel (2002) file which I'd like to use in a mailmerge
but unfortunately all text entered previously is in uppercase. I've found
the function Proper() which corrects uppercase to first letter as a capital
then the rest as lowercase, but.... it appears that it can only be used to
convert individual cells into a new/adjacent cell (i.e not simply convert
the existing cell.
Can anyone help me overcome this problem please?
Cheers
Bill