LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 10
Default Cutting first 4 digits from a cell and pasting it into an adjacent column

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cutting and Pasting with spaces pm Excel Discussion (Misc queries) 1 September 25th 07 08:32 PM
Cutting and Pasting in Excel Rev. Munchkindad Excel Discussion (Misc queries) 19 September 5th 07 08:40 PM
Data validation vs. cutting pasting Illya Teideman Excel Discussion (Misc queries) 0 August 22nd 07 12:32 PM
Cutting and Pasting cells from horizontal to multi vertical column Ms SDB Excel Worksheet Functions 4 January 22nd 07 09:20 PM
Formats when cutting and pasting Kayle Z Excel Discussion (Misc queries) 1 February 9th 06 03:57 AM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"