Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
extracting characters at a specified limit to seperate cells
I have a table of multiple parts descriptions ranging from 40
characters to 600 characters in length, in order to import this into my data base the description cannot be longer than 75 characters, how would i go about seperating the descriptions at the 75 character mark and then extracting them into a new cell. Here is an example of one of my descriptions SAW MOTOR~KF 62.01~CAPACITY : 1.3 KW~MODE OF OPERATION: S1~MOTOR SPEED : 3430 RPM~VOLTAGE : 460 V~FREQUENCY : 60 HZ~NOM.CURRENT : 2.85 A~PROTECTION IP 54~INSULATION CLASS F~TYPE : B3~TERMINAL BOX : 3B~BRAKE VOLTAGE : 460 V~BRAKE TORQUE : 4 NM~BLUE-GRAY~COLOR RAL 7031~WITH THERMAL SWITCH~WT/160 C~CSA/UL - MOTOR TYPE SIGN~K 62 S/2-G4K~PART-NO. 99324899~DOC-NO. 87160003/50 which essentially needs to turn into 4 sets of 75 char cells so that i can import them into the comment field in the database i.e. A1 = Saw motor .................... B1= 330 RPM............. etc thanks for all your help p.s. i have about 5000 of these descriptions that need to be extracted (i also have to keep the ~since this specifies the carriage return for the print outs) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
"Weird" characters in cells | Excel Discussion (Misc queries) | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
255 characters in cells | Excel Discussion (Misc queries) | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) |