banner_ad

Excel problem

Excel 906 views 4 replies

Dear Sir,

please check the excel file and guide/tell me how change the format of the cell to get required output

 

Please please someone solve this problem

 


Attached File : 464578 1267058 problem.xlsx downloaded: 205 times
Replies (4)

see the answer

No i don't want to use the functions 

If i select that cell in the (address H3) it should display " Class-I Ram" but if i press F2 (Function key) it should show only "Ram"

use "concatenate" function & then paste values using 'paste special'

Please find required solution


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 02 May 2026
Senior Executive

hitesh chandwani & co

Pune

B.Com

View Details
Company
Featured 29 April 2026
Manager- Finance and Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
Featured 14 April 2026
GST CONSULTANT

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 13 April 2026
GST CONSULTANCY

Abhishek G Agrawal & Co.

Korba

CA Final

View Details
Company
Featured 28 March 2026
Accountant

Ashok Amol & Associates

New Delhi

B.Com

View Details
Company
Featured 28 March 2026
CA Final

Ashok Amol & Associates

New Delhi

CA Final

View Details
Company
Featured ARTICLESHIP 19 March 2026
Article Assistant

Gupta Sachdeva & Co. Chartered Accountants

New Delhi

CA Final

View Details
Company
Featured 14 March 2026
Associate CA

N N V Satish&co

Hyderabad

CA

View Details