BlackPanther
New Member
- Joined
- May 11, 2015
- Messages
- 21
Dear all
I have a problem in splitting the data :
2-890
3-457
4-464
5-348
Jan - 99
4-567
4-576
Feb - 00
and goes on
i used text to columns to split and show 2 & 890 in separate columns
but it also shows some months , which is an error , i just want to show 99 in those cells, & remove the months( infact i dont want the month to appear )
is there any formula for the same?
Thanks in advance
I have a problem in splitting the data :
2-890
3-457
4-464
5-348
Jan - 99
4-567
4-576
Feb - 00
and goes on
i used text to columns to split and show 2 & 890 in separate columns
but it also shows some months , which is an error , i just want to show 99 in those cells, & remove the months( infact i dont want the month to appear )
is there any formula for the same?
Thanks in advance