proper case

hi,

this is how data comes down from a main frame

ASHFORD CONSTRUCTION PLC GRANVILLE STREET
Try Homes (Southern) Ltd 27 ALLINGTON ROAD
ELIZABETH HOUSE

this is in 2 columns
i want to copy this data to another worksheet but when i do i want it to be shown with capital letters followed by lower case

thank you
steve

Hi,

You can use the proper() function on the destination cells.

Hope this helps,

HI,

Can this be done with a macro

steve