You can do it easily do it, if you don't mind your value appearing in a
different cell.

Use the formal =UPPER(Cell)

There is also =Lower(Cell)

There is also =Proper(Cell)

Hope this helps.
Steve

"reza" wrote:

Dear All,

if i write something in cell, how to make automatically become capital/upper
text.
i.e.
in A1...if i write family...i want automatically become FAMILY in that cell...

hoping one of you can help me

thanks

regards,
reza