Want to get the Numbers

Board Regular
Hi All,

I have the set of numbers like 123456789123, 345689733848 etc in Column A.
I want to get the numbers except the first 10 digits.

the numbers are not same the same digit. sometimes it is 14 and some times it is 12.

So I want the last 4 or 2 digits. I do not apply the "Text to Column" option.

Is there any formula to do that?

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Try

=RIGHT(A1,LEN(A1)-10)+0

=right(A1,4) would give you the last 4 digits
=right(A1,2) would give you the last 2 digits

=left gives you the first digits in the cell

Hi

Perhaps this would work?

Code:
``=VALUE(LEFT(A1,LEN(A1)-10))``

HTH

For ex., for

12345123450123

You want the result as a number

123

or as text

0123

?

So I want the last 4 or 2 digits. I do not apply the "Text to Column" option.

Why not? Seems the easiest solution.

Replies
2
Views
446
Replies
1
Views
145
Replies
1
Views
133
Replies
2
Views
433
Replies
9
Views
485

1,203,221
Messages
6,054,224
Members
444,711
Latest member
Stupid Idiot

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back