can I delete the 1st number from a string of numbers
 

can I delete the 1st number from a string of numbers without adding another
column for the formula?

can I delete the 1st number from a string of numbers
 

Maybe...

But what's wrong with using another column of formulas?

Jessica wrote:

can I delete the 1st number from a string of numbers without adding another
column for the formula?

--

Dave Peterson

can I delete the 1st number from a string of numbers
 

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




"Jessica" wrote in message
...
can I delete the 1st number from a string of numbers without adding
another
column for the formula?

can I delete the 1st number from a string of numbers
 

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.



"Jessica" wrote:

can I delete the 1st number from a string of numbers without adding another
column for the formula?