Unanswered: How to change excel fields value to another value?
Hello, I need help. I have an excel sheet where I have a cells with values:
I want to know how to convert :
TRSMED to 333990
TRSPOT TO 333991
TRSMAT TO 333992
In order to get:
You could just insert a column after your column with TRSMED, TRSPOT, etc.
then in the new column next to TRSMED(Cell A1) put in 333990(Cell B1) and next to TRSPOT(Cell A2) put in 333991(Cell B2). Once you have done this you can highlight Cell B1 and B2 only. Then drag the little black plus sign in the bottom corner of Cell B2 to automatically fill in the sequential numbers.