IN EXCEL THREE, SIX FIVE, HOW TO FIND AND EXTRACT THE SPECIFIED CONTENT OR VALUE IN A CELL TO ANOTHE

If the power of column e does not have a decimal place, or if the number of the integer part is larger than the number of the decimal part although it has a decimal, you can try the following formula:

f7=-min(-text(right(mid(e7,find("w",e7)-6,6),)"#

Drop down. Formula description: find the position where the symbol w of the power unit in e7 is located, and then go back 6 positions to start taking 6 characters, such as in e7:

Power: 480

Then use right to take 1 to 6 characters from right to left

480, rate: 480, power: 480

Then text, set the pattern for the 6 retrieved strings, followed by 3 semicolons in English double quotation marks, a total of 4 possible numeric formats:

Positive:0, i.e. a number with 1 decimal place.

Negative numbers: Separated by semicolons directly, because negative numbers are not possible, so they are ignored.

0:0, still 0

Text: 0, forced to 0 (convert it to a number for later processing).

In this way, text represents the 6 strings as:

But 6 numbers are in text format, so add a negative number in front of the text to convert it to a number:

Among the 6 numbers, the smallest number, that is, the absolute value is the largest, is taken out with min, and then a negative sign is added in front of it to restore it to a positive number. You can also add 2 minus signs in front of text to convert the word number into a number, and then use max to take the largest number.

<>-lookup(,-right(left(e7,find("w",e7)-1),row($1:$9)))"w"

There can be no w before this formula extracts the power position, otherwise you have to use another formula.

No test, maybe bugs, hope it helps!

F7 cell:

if(find("Power:",e7)>0,mid(e7,find("Power:",e7)+6,find("w",e7)-(find("Power:,e7)+5)),mid(e7,find("，",e7)+2, find("w",e7)-(find("，",e7)+1))

<>mid(e2,find("Power:",e2)+3,find("w",e2)-find("Power:",e2)-1)

Is it the result you want.

Helpful, please give a thumbs up, thank you.

F7 cell input formula=iferror(lookup(9 9,--mid(e7,find("Power:",e7)+3,row($1:$9)))lookup(9^9,--right(left(e7,find("w",e7)-1),row($1:

Find the location of the "Power:" content and extract the number immediately to the right of it, and if there is no "Power:" in the cell, find it"w"this letter and extract the number to its left. Example.

=mid(e7,find("Rate:",e7)+2,find("w",e7)-find("Rate:",e7))

Find Rate: , in the position of E7.

Look for w, at the location of E7.

Their difference is in the digits.

Then use the mid function to extract.

Is it the specification of 2 cases? Is there a power value with a word and without a word but with a number w plus a comma?