Hello Sirs/Madams.
tell me how to print each character in each cell, when we type a word in a cell.
If I type "RAJ KUMAR" in excel sheet in A1 cell, now I Want this name like 'R' in B1 cell , 'A' in B2 cell, 'J' in B3 cell so on.
Mohammed Yakub Pasha (Clerk in a Chartered Accountant Office) (24 Points)
20 April 2012Hello Sirs/Madams.
tell me how to print each character in each cell, when we type a word in a cell.
If I type "RAJ KUMAR" in excel sheet in A1 cell, now I Want this name like 'R' in B1 cell , 'A' in B2 cell, 'J' in B3 cell so on.
@VaibhavJ
(Believe!! Live your dreams!)
(33516 Points)
Replied 30 October 2013
Hi,
This can be done thru simple formula.
See attached file!!
Cheers
Mr. Patnaik
(Sr. Accounts)
(35 Points)
Replied 27 November 2013
Hi
Try this with out any Helper Column
Say your name Contains in Cell A1
in B1 use this formula
=MID($A1,COLUMN()-1,1)
copy across and down