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 Topic
- ITR form query
- Credit against paud RCM on rent
- Dividend difference in 26AS, AIS, TIS
- 194JB INCOME
- Filing ITR3 where income under section 44AD with L
- What is superannuation fund
- GST Refund of input services under Inverted Duty S
- Dividend Reporting
- Real operational bottlenecks after firms use Tally
- Purchase return under gst
Related Topics
CAclubindia
