Batch Update Text Cell Format


#1

Is anyone aware of a method to batch update the format of text in a cell?

i.e. I have a database of names where I want the first letter of both first and last name to be capital. Is it possible to batch update them with either a Block or formula?

Thanks in advance