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
- ITR 2 filing error after validation
- ITR filing STCG LTCG
- TDS deducted against PF withdrawal
- VRS / Severance Pay full exemption u/s 89 ( 10E fo
- Sponsorship fees GST
- Error in verification of ITR-2
- Form 12aa for Religious and Charitable trust
- Schedule 112A CSV template
- RNOR status and exemption on RFC account interest
- Upload error for ITR 2 filing after validation
Related Threads
CAclubindia
