Extract Specific Number of Characters After a Word

[KungFu Keyboard]

Hi there,

How do I extract just 3 characters after a specific word in a cell. Below A2 has a bunch of information jammed into 1 cell. I need to grab just the 3 characters after the word "loadsheet". The blah blah blah is a bunch of random junk that i don't need.

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

Regards,
Bernard

 

[Joe4]

In your example, it assumes that you are also assuming a single space after your word, which you do not want to include in your 3 character pull.
For an entry in A1, the formula might look something like this:

=MID(A1,FIND("loadsheet",A1)+LEN("loadsheet")+1,3)

 

[KungFu Keyboard]

That worked a treat! Thanks Joe

 

[Joe4]

You are welcome!

 

[KungFu Keyboard]

Just out curiosity, how would the formula look if i were to pull characters before the word

 

[Joe4]

Something like this (assuming there is a blank space that you want to exclude):

=MID(A1,FIND("loadsheet",A1)-4,3)

Hopefully, these solutions make sense. If you walk through them, the logic should be pretty straightforward.
Let me know if you have any questions about them.