Excel problem

SAGAR (ARTICLED ASSISTANCE) (236 Points)

02 January 2014

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

Reply
Follow
Share

4 Replies

NOUFAL (ACCOUNTANT) (762 Points)
Replied 02 January 2014

see the answer

Attached File : 734452 1267061 solve.xlsx downloaded: 239 times

1 Like

SAGAR (ARTICLED ASSISTANCE) (236 Points)
Replied 02 January 2014

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"

CA Prateek Garg (CA in Practice) (1447 Points)
Replied 17 January 2014

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

CA Kumar Mukesh (CA CMA FINAL and Advance Excel Trainer) (6881 Points)
Replied 24 January 2014

Please find required solution

Attached File : 304961 1276841 464578 1267058 problem.xlsx downloaded: 249 times

Start a New Discussion