Need help reformating data

fullthrottlecb

New Member
Joined
Mar 10, 2011
Messages
5
I have a csv file I need to reformat here is my raw data

01099-001-290
01099-001-289
01099-001-288
01126-018-005
01126-018-006
01129-001-007
01129-001-005
01129-001-004
01129-001-003
01129-001-006
01129-001-002
01132-005-007
01132-005-006
01133-001-007
01133-001-005
01133-001-004
01133-001-003
01133-001-006
01133-001-002
01149-001-290
01149-001-289
01149-001-288
01155-011-005
01155-011-004
01155-011-003
01155-011-006
01157-001-007
01157-001-005
01157-001-004
01157-001-003
01157-001-006
01157-001-002
01175-017-005
01175-017-004
01175-017-003
01175-017-006
01175-115-005
01175-115-004
01175-115-003
01175-115-006



here is what is need
The format of the numbers is always the same.
I need the first five character on a row by itself and then I need the rest in the next column and next rows.
Example is below.
Underscore is to represent a blank cell.

___A______________B
1 01099
2__________ 01099-001-290
3 __________01099-001-289
4 __________01099-001-288
5
6 01126
7 __________01126-018-005
8 __________01126-018-006
9 01175
10 _________01175-017-005
11 _________01175-017-004
12 _________01175-017-003
13 _________01175-017-006
14 _________01175-115-005
15 _________01175-115-004
16 _________01175-115-003
17 _________01175-115-006

Any help would be appreciated.

Thanks
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,224,598
Messages
6,179,822
Members
452,946
Latest member
JoseDavid

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top