Separate first and last names in same cell

[JamesT1]

Hi Folk

Is there a quick way to seperate first and last names which are in the same cell..... they are also in CAPITALS and I would like to put them into Upper and Lower casing

Thanks in advance

[JBeaucaire]

To separate out words, try the Data > Text To Columns wizard.

To change the actual values in the cells from all uppercase to PROPER() case would require:

1) A formula in another cell to give the answer in the new cell: =PROPER(A1)

2) VBA to change the original cells directly

[JamesT1]

JBeaucaire

many thanks for your help,,, worked a treat for me and saved many hours,,,,,