Splitting data from the right side with no delimiters

Bunsen

New Member
Joined
Sep 17, 2014
Messages
10
I have a column of numbers that I need split into three columns. The numbers can have 8,9 or 10 digits. I need to split from the right into three columns
Current data

235000035
75000035
1865000035

<tbody>
</tbody>

Desired result
235000035
75000035
1865000035

<tbody>
</tbody>

Any help is greatly appreciated.
Thanks
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
For an entry in A1:
in cell B1: =LEFT(A1,LEN(A1)-7)
in cell C1: =MID(A1,LEN(A1)-6,4)
in cell D1: =RIGHT(A1,3)
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,103
Office Version
365
Platform
Windows
You are welcome.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,400
Messages
5,450,177
Members
405,591
Latest member
Musiclover

This Week's Hot Topics

Top