Cutting first 4 digits from a cell and pasting it into an adjacent column

[weewillie]

Using 2007 on Vista

I've got some data I want to import from excel into my crm software
For type of business here in the UK we use 'SIC' codes
However, the data I have purchased has the SIC code followed by it's
description
I want to seperate the first 4 digits which is for the SIC code and
leave the description behind as per the following

data
3320: Manufacture Of Instruments & Appliances For Measuring, Checking,
Testing, Navigating & Other

Which I want to seperate into
SIC code 3320
SIC description Manufacture Of Instruments & Appliances For
Measuring, Checking, Testing, Navigating & Other

There's 1300 lines
How do I do this please?

 

[gls858]

Using 2007 on Vista

I've got some data I want to import from excel into my crm software
For type of business here in the UK we use 'SIC' codes
However, the data I have purchased has the SIC code followed by it's
description
I want to seperate the first 4 digits which is for the SIC code and
leave the description behind as per the following

data
3320: Manufacture Of Instruments & Appliances For Measuring, Checking,
Testing, Navigating & Other

Which I want to seperate into
SIC code 3320
SIC description Manufacture Of Instruments & Appliances For
Measuring, Checking, Testing, Navigating & Other

There's 1300 lines
How do I do this please?

Excel has a function called text to columns. Check the help files to see
how this functions. If you have any question on it's use just post back.
It's pretty self explanatory.

gls858

 

[weewillie]

Excel has a function called text to columns. Check the help files to see
how this functions. If you have any question on it's use just post back.
It's pretty self explanatory.

gls858

Great Help, many thanks
It was a doddle

 

[gls858]

Great Help, many thanks
It was a doddle

Glad to help. Thanks for posting back.

gls858