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.
Menu
How to print each character in separate cell
Replies (2)
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
Recent Topics :
- Difference between AIS and 26AS data.
- Applicability of FCRA to Article Processing Fees (
- GST Return
- Practical queries on buy back of shares
- Any faculty recommendations for latest batch recor
- FAI & FAST-DS 2026 query
- Is GST registration mandatory in this case
- Buying a residential flat in Goa: should my wife b
- Income tax filling
- Applicability of RCM in the case of import of serv
Related Topics :
CAclubindia
