Hello,
I am working on an Excel 2010 worksheet organized as as follows:
A B
1 blah..blah..KEYWORD 11.1..blah..blah..
2 blah..blah..KEYWORD 0.1..blah..blah..
3 blah..blah..KEYWORD 100..blah..blah..
.
blah..blah = both text and numeric. There's a space between KEYWORD and number
I would like to be able to have the numbers (integers, or having 1 or 2 decimal places) following the KEYWORD returned in blank adjacent cells as shown below:
A B
1 blah..blah..KEYWORD 11.1..blah..blah.. 11.1
2 blah..blah..KEYWORD 0.1..blah..blah.. 0.1
3 blah..blah..KEYWORD 100..blah..blah.. 100
Thanks in advance for any help.
xu9j2
Bookmarks