Ron I would like to then extract the remaining characters into another
cell
Ron Rosenfeld wrote:
On 28 Dec 2006 08:17:24 -0800, "tevid" wrote:

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)

If you don't care how they break, then Dave's solution should be fine.

If you want the break to be in some logical spot, e.g. after a tilde, then you
will need a different method.

Also, your example has 372 characters. 4 sets of 75 will only give you the
first 300 characters. Do you want to discard the 72 extra characters? Or put
them in a fifth (or sixth or more) cell?


--ron