I found a column of data that has similar data (not exact) as below.
AVINGER NATURAL GAS 351MW WILKES UNIT #3 UPGRADE
I need to extract the ###MW from this column and place it in column 'FQ'.
Any suggestions?
I found a column of data that has similar data (not exact) as below.
AVINGER NATURAL GAS 351MW WILKES UNIT #3 UPGRADE
I need to extract the ###MW from this column and place it in column 'FQ'.
Any suggestions?
Is it always 3 numbers?
Going for Guru! Click the Star to the bottom left of this post if I helped!
Assuming it's always 3 numbers, and the text string MW is always in caps, and never contained in any other context, and this is in A3, you can type the following in cell FQ3:
=MID(A3,FIND("MW",A3)-3,3)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks