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: 213 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
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
21 July 2026
Chartered Accountant

Keshri & Associates

Thiruvananthapuram

CA

View Details
Company
ARTICLESHIP 14 July 2026
Article Assistants

R Shyam and Associates

New Delhi

CA Final

View Details
Company
ARTICLESHIP 15 July 2026
CA Articles

Kinjal H Shah & Co.

Mumbai

CA Foundation

View Details
Company
ARTICLESHIP 23 July 2026
Article

Gianender & Associates

New Delhi

CA Inter

View Details
Company
14 July 2026
Senior Executive/ Manager

H S SHARMA AND CO

Pune

CA Final

View Details
Company
29 July 2026
ACCOUNTANT

ONESTEP GST SOLUTION

New Delhi

B.Com

View Details
Company
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details
Follow