Vishaal
Well-known Member
- Joined
- Mar 16, 2019
- Messages
- 533
- Office Version
- 2010
- 2007
- Platform
- Windows
- Web
Hi All,
Thanks in advance
I have the following sheet
Excel 2010 32 bit
Want the following result
Excel 2010 32 bit
tried the following but not find the result
1) IF(VALUE(MID($A2,COLUMNS($B$1:B1),1))=0,"",MID($A2,COLUMNS($B$1:B1),1))
Help pls
Thanks in advance
I have the following sheet
Excel 2010 32 bit
A | |
---|---|
1 | 04 |
2 | 45 |
3 | 65 |
4 | 02 |
5 | 90 |
6 | 06 |
Sheet: Sheet1 |
Want the following result
Excel 2010 32 bit
A | B | C | |
---|---|---|---|
1 | 04 | 0 | 4 |
2 | 45 | 4 | 5 |
3 | 65 | 6 | 5 |
4 | 02 | 0 | 2 |
5 | 90 | 9 | 0 |
6 | 06 | 0 | 6 |
Sheet: Sheet1 |
tried the following but not find the result
1) IF(VALUE(MID($A2,COLUMNS($B$1:B1),1))=0,"",MID($A2,COLUMNS($B$1:B1),1))
2) =MID($A2,COLUMNS($B$1:B1),1)
Help pls
Last edited: