T
T Miller
I need to remove a value in a cell and place only that value in the next
cell, example:
Column One Column Two
CS/4 BX/40 EA 40
CS/72 EA 72
EA 1
Is there an IF statement that can do this? I have 1200 rows of these and I
need to just have the last number in column two and where there is text(EA) I
need it to show the number 1? Can this be done?
cell, example:
Column One Column Two
CS/4 BX/40 EA 40
CS/72 EA 72
EA 1
Is there an IF statement that can do this? I have 1200 rows of these and I
need to just have the last number in column two and where there is text(EA) I
need it to show the number 1? Can this be done?