can I delete the 1st number from a string of numbers without adding another column for the formula?
J Jessica Feb 8, 2006 #1 can I delete the 1st number from a string of numbers without adding another column for the formula?
P Peo Sjoblom Feb 8, 2006 #3 How about using a formula in a help column, then paste the formula result as values over the old values and finally delete the help column. Otherwise it requires code -- Regards, Peo Sjoblom Portland, Oregon
How about using a formula in a help column, then paste the formula result as values over the old values and finally delete the help column. Otherwise it requires code -- Regards, Peo Sjoblom Portland, Oregon
E exceluserforeman Feb 9, 2006 #4 Assuming B2 is the Cell of string numbers =MID(B2,2,LEN(B2)-1) It doesn't delete the 1st number but just gives you the other numbers without the 1st number.
Assuming B2 is the Cell of string numbers =MID(B2,2,LEN(B2)-1) It doesn't delete the 1st number but just gives you the other numbers without the 1st number.
