MID without cutting words

[azdub2]

I need to update a form that I can only have 70 characters per line. The problem is when I use MID it cuts words off. For the sentence: Inspect compressor/inlet area for fod and oil leaks. Check GP section for freedom of rotation with no binding. Rotate compressor rotor and listen for unusual noises.


It should read.

Inspect compressor/inlet area for fod and oil leaks. Check GP section
for freedom of rotation with no binding. Rotate compressor rotor and listen
for unusual noises.

What I'm using sort of works:

=IF(ISNUMBER(SEARCH(" ",A2,60)),LEFT(A2,(FIND(" ",A2,60)-1)),A2)

=IF(ISNUMBER(SEARCH(" ",A2,60)),MID(A2,SEARCH(" ",A2,60)+1,SEARCH(" ",A2,60)-SEARCH(" ",A2,1))," ")

=IF(ISNUMBER(SEARCH(" ",A2,120)),MID(A2,SEARCH(" ",A2,120)+1,SEARCH(" ",A2,110)-SEARCH(" ",A2,60))," ")

What I get cuts the second line off:

Inspect compressor/inlet area for fod and oil leaks. Check GP
section for freedom of rotation with no binding. Rota
rotor and listen for unusual noises.


My sentences may be longer so that's why I have 2 MIDs, not sure if I can even have 2 MIDMIDs

[AlKey]

Assuming the text string is in A2

Enter this formula in A3 and copy it few rows down

Please Login or Register  to view this content.

Enter second formula in B2 and copy down

Please Login or Register  to view this content.