KungFu Keyboard
New Member
- Joined
- Oct 22, 2016
- Messages
- 26
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.
<tbody>
</tbody>
Regards,
Bernard
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.
description | output |
loadsheet 001 blah blah blah | 001 |
<tbody>
</tbody>
Regards,
Bernard