Input Masks in Excel

[cjashwell]

Hi
Does anyone know if there is a way of setting up an Excel cell with some kind of 'input mask' that will automatically capitalise any alpha characters that are entered? I can't seem to find the function within the cell formatting menu, but perhaps I'm not looking in the right place?
Thanks in advance for any help anyone can offer.
CJA

 

[Hasit]

I am not aware of an input mask as you describe, but perhaps an interim solution until someone comes up with some code could be:

=PROPER(A1)

where A1 is the cell you enter the data in. This could be a pain because you would need a second column/row to add the capitalised data.

 

[cjashwell]

Thanks Hasit, that's a very useful work around.

Best wishes,
CJA