Excel problem

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: 227 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

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 07 November 2026
Chartered Accountant

DPV & Associates

Chennai

CA

View Details
Company
21 October 2026
CA INTER/ BCOM WITH EXPERIENCE

CA S KUMAR GUPTA & CO

Amritsar

CA Inter

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
13 November 2026
Charted Accountant - Fresher

Neeraj Bhagat & Co

New Delhi

CA Final

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details