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 :
- Free CA Foundation Study Material - PYQs with Sugg
- INCOME TAX
- Moving from old to new tax regime after notice
- Need urgent help on notice
- ITR-3 - F&O Loss adjusted against business inc
- Error - Blank Rows in Schedule SI (ITR-2)
- Dividend from co-operative society
- SECTION 139(10) OF THE COMPANIES ACT, 2013 CASE
- TDS u/s.194C returns filed in ITR-1
- TDS on Property - Form 26QB Related
Related Topics :
CAclubindia
