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?

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

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" <[email protected]> wrote in message
news:[email protected]...
> can I delete the 1st number from a string of numbers without adding
> another
> column for the formula?

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?