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

[Jessica]

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

[Dave Peterson]

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

[Peo Sjoblom]

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" <Jessica@discussions.microsoft.com> wrote in message
news:43084D22-CAFD-40F2-BF1E-FEF40F193636@microsoft.com...
> can I delete the 1st number from a string of numbers without adding
> another
> column for the formula?

[exceluserforeman]

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?