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.
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.
Hi,
This can be done thru simple formula.
See attached file!!
Cheers
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
Karia Overseas
Ahmedabad
CA
View Details
CMNITY HIRE
New Delhi
Others
View Details
Shyam Joshi & Associates
Pune
B.Com
View Details
Sri Aurobindo Gnostic Centre of Education
New Delhi
CA
View Details
CAclubindia
