Blackie50
03-22-2012, 07:09 AM
Hi,
Is there any way to convert a capitalized full name to the following either by formula or code e.g
MR P BLOGGS to Mr Bloggs
MRS R FALKINGHAM to Mrs Falkingham
I tried using left/right/lower but the numbers to convert change each time
thanks for any help
Jon
Is there any way to convert a capitalized full name to the following either by formula or code e.g
MR P BLOGGS to Mr Bloggs
MRS R FALKINGHAM to Mrs Falkingham
I tried using left/right/lower but the numbers to convert change each time
thanks for any help
Jon