'Proper' Function in Excel

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.

Replies (6)

It is not possible.

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

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..

See solution from below link.

 

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

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

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

Hi,


You can directly use the function in cell A3. You need to type =Poper("chartered accountants")...

Hope this will suffice your requirement.

Regards,

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
10 November 2026
FP&A Executive

Gujarat Guardian

Ankleshwar

CA Final

View Details
Company
19 November 2026
Accounts & Taxation Executive

MCSR and Associates LLP

Hyderabad

CA Inter

View Details
Company
21 November 2026
Asst. Manager / Deputy Manager

Aco Perfumes & Cosmetic Pvt Ltd

Mumbai

CA

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details