Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cutting and Pasting with spaces | Excel Discussion (Misc queries) | |||
Cutting and Pasting in Excel | Excel Discussion (Misc queries) | |||
Data validation vs. cutting pasting | Excel Discussion (Misc queries) | |||
Cutting and Pasting cells from horizontal to multi vertical column | Excel Worksheet Functions | |||
Formats when cutting and pasting | Excel Discussion (Misc queries) |