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

  • Thread starter Thread starter weewillie
  • Start date Start date
W

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?
 
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?
Click to expand...

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
 
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
Click to expand...

Great Help, many thanks
It was a doddle
 
Back
Top