return 5 characters before a specific word

[KungFu Keyboard]

Hi there,


How do I extract just 3 characters before a specific word "loadsheet" within a cell

[TABLE="width: 500"]
<tbody>[TR]
[TD]description[/TD]
[TD]output[/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]blah blah auh cpt loadsheet blah blah[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]cpt[/TD]
[/TR]
</tbody>[/TABLE]

Regards,
Bernard

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/excel...ct-specific-number-characters-after-word.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).