Formula for text extraction

I have the following formula in a cell in order to extract a specific value from a text box. =MID($A2,FIND($F$1,$A2)+LEN($F$1)+2,20)
The issue is that 20 characters at the end runs into a diferent section which I don't want here. I need to keep it 20 because that is how long the text string I need is. I want this fomula to be universal for all of my text cells.
How can I add to this fomula, keeping the 20 character length, but making it stop giving values once it reaches the next word in the text box?

See details in attachement

Title OK. Post removed

While you are changing your title, please post an Excel sheet, too. Without seeing some representative examples, this involves way too much guesswork.

So sounds like you only want complete words so if 20 characters would cut a word in half, you'd want less than 20 characters.

With your string in A1, try
=TRIM(LEFT(SUBSTITUTE(A1," ",REPT(" ",20)),(20-LEN(SUBSTITUTE(LEFT(A1,21)," ",""))+1)*20))

I see

Try this
=TRIM(MID(SUBSTITUTE(A2,CHAR(10),REPT(" ",20)),FIND($D$1,SUBSTITUTE(A2, CHAR(10), REPT(" ",20)))+21,20))

Yeah, you have so much going on here, I'm not sure you can catch everything.

"General Job Completion Notes" occurs twice in each cell in A and has an immediate line break after it. So I fixed that in Column A.
I modified the formula So it's always looking at the proper header and calculating an offset based on the length of that header.

This probably would require VBA to fix everything. Perhaps you should post in the Excel Programming folder.

Your sheet looks much better for all the smaller fields. However, the job notes field is most important to me. Any other ways I can extract that data better? It's difficult because what I'm given is inconsistent.
The comment boxes are enetered in the computer this way by others. So I have to make them show the fields properly as they are.
Also, why are some of your fields blank? You used a "Iferror" wrapper so It should give "N/A" right?

Do you want the job notes to be longer than 20 characters?

I don't see any fields that came back blank.

The fields in green (N4, M4, D3). Yes I would like the entire job notes description in the "general job completion notes" cell. I would like it to stop prior to the next subject/category. Is there a way to make the formula see where that text string ends?

Okay, for the General Job Completion Notes, in D2 put

=TRIM(MID(A2, SEARCH($D$1&":",A2)+LEN($D$1)+2, SEARCH(CHAR(10)&CHAR(10),A2)-(SEARCH($D$1&":",A2)+LEN($D$1)))) copied down
This assumes that after the Job Notes, there is a double line break (CHAR(10)&CHAR(10)) which is not true for your last entry in Col A of your example. You'd need to manually enter a line break before "Paperwork Completed by:

For the other columns
In E2 copied down and to appropriate columns
=IFERROR(TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",100)),FIND(E$1,SUBSTITUTE($A2, CHAR(10), REPT(" ",100)))+LEN(E$1)+1,100)), "N/A")

How does that work?

The originals are too varied to do much better. I went back to your file in Post #8
If you follow these steps it will be mostly good.
Step 1
Select Col A and hit CNTRL H to bring up Find/Replace Window
Find: space [Alt + 010]
Replace with: [Alt + 010]
Keep hitting the replace All button until it comes up not found

Step 2
Clear the Find/Replace Windows
Find: colon space
Replace with: Colon
repeat Replace All until no more

Step 3
Find: colon [Alt + 010]
Replace with: colon

In D2 copied down
=TRIM(MID(A2, SEARCH($D$1&":",A2)+LEN($D$1)+2, SEARCH(CHAR(10)&CHAR(10),A2)-(SEARCH($D$1&":",A2)+LEN($D$1))))
In E2 copied across and down
=IFERROR(TRIM(MID(SUBSTITUTE($A2,CHAR(10),REPT(" ",100)),FIND(E$1,SUBSTITUTE($A2, CHAR(10), REPT(" ",100)))+LEN(E$1)+1,100)), "N/A")

This is the result. Someone in Excel Programming Folder could macro this procedure.

For D3:D5 change that "+2" to "+1"

For N4, I set the string lengths to 100 and that one is a whopping 358. I will play with it a bit

For the second formula starting in E2, change all the 100's to 400's. I checked and it doesn't affect any of the other results, just fixes N4

As I mentioned above, you need to do some find and replaces on Column A first
I did 2
1) Find ":ALT+10" (hitting Alt 010, not typing it)
replace with : space
2) find ": space ALT +10"
Replace: ": space"
Look better?