Dear all, i have two cell, A1 is input and B1 is output. how to remove 7 and 8 number character from cell A1,
character start from left to right , please check the bellow example.
CELL A1 > CELL B1
2010-6-1-A-100 > 2010-6-A-100
2011-7-2-A-2 > 2011-7-A-2
2012-8-3-A-3 > 2012-8-A-3
2010-6-1-A-4 > 2010-6-A-4
2011-7-1-A-5 > 2011-7-A-5
2012-8-1-A-6 > 2012-8-A-6
............................
............................
for example:
character 12345678
2010-6-1-A-1
so if i count from left to right, i want to remove 7 and 8 number charecter all time
Bookmarks