I need to search for then extract a specific portion of cell data.
Ken,
I tested this in your sample and it appears to work BUT I cannot
guarantee it is "foolproof"!
=VALUE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A 1,"("," "),"x","
"),")",""),FIND(" ",SUBSTITUTE(SUBSTITUTE(A1,"("," "),"x"," ")),255)))
HTH
"Ken" wrote:
I need to search for then extract a specific portion of cell data. Below, I
have provided an example of what I'm trying to do.
Column "A" (raw data) Column "B" (end result)
700001103 (x4) 4
8675-US (59) 59
8675-EU x 5 5
6330-02(18) 18
6330-02CE (x10 ) 10
6305-02 (1) 1
58516 (x117) 117
I hope someone can help me.
Thanks.
//Ken
|