Formatting Text

[Newtransistorhero]

Hello

Is there a way i can make excel change the text in cells to make it look as though the cell is a title

For example

i want

north lancashire

to read

North Lancashire

i have a lot of these to do and i think it would save manually changing every one

thanks

[DonkeyOte]

You might be able to use PROPER function ? eg:

=PROPER(A1)

then: copy result(s) -> paste special -> values only over the original(s)

If you want to update multiple cells simultaneously with VBA let us know.

[Newtransistorhero]

Many thanks, works a treat

there are so many fuctions i never knew about, i may buy one of the guides

Thanks