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.
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
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 |
 |
Kapil Malde
(198 Points)
Replied 21 September 2010
Hi,
You can directly use the function in cell A3. You need to type =Poper("chartered accountants")...
Hope this will suffice your requirement.
Regards,
CAclubindia
