LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

'Proper' Function in Excel

Varun.T.K (CA Final, CS Executive) (365 Points)

20 September 2010

Kindly let me know how to use the function proper in the same cell where the user is working.

To illustrate,

In a cell A3, I have the word 'chartered accountants'

By using the proper function, i should get the desired result in the same cell. (ie, proper function to be applied in the same cell-A3 and no cell other than that.)

Pls help me to solve this particular query.

Reply
Follow
Share

6 Replies

CA Subin VR (Practicing CA) (450 Points)
Replied 20 September 2010

It is not possible.

You have to copy and paste the Proper Letters to the destination cell.

JINESH SHAH (PRACTICING CA) (151 Points)
Replied 20 September 2010

want to modify above little... first put formula in any different cell n then copy it n do paste special n select values only in the cell u want to change..

Exshail (Software) (1576 Points)
Replied 21 September 2010

See solution from below link.

/forum/capital-to-small-case-104259.asp

anandgowda (Audit assistant) (34 Points)
Replied 21 September 2010

Dear Varun

Type 'chartered accounts' in Cell A3, then use =poper function in next sell i e A4 then u get result as 'Chartered Accounts' then copy the cell A4 then use paste special function, vaules in the cell A3 u can view the words in cell A3

Santosh (Student ( Final Year - New )) (348 Points)
Replied 21 September 2010

Originally posted by : anandgowda
	Dear Varun Type 'chartered accounts' in Cell A3, then use =poper function in next sell i e A4 then u get result as 'Chartered Accounts' then copy the cell A4 then use paste special function, vaules in the cell A3 u can view the words in cell A3