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 Threads
- Is MirrorFly an Instant Messaging Software?
- ITR filling for legal heir
- How Can I qualify CA Final Exam?
- Wrong reporting on 22 april 2026 under article inc
- Articeship Form 107
- TAN for Multiple States
- Delivery Challan serial number Issue and return ru
- After filing form 71 For TDS mismatch
- UNCLAIMED TDS REFUND QUERY
- Rcm payable which head
Related Threads
CAclubindia
