Need help with a string

**aznj50** · 10-15-2012, 05:49 PM

Victorian Ruffles Princess Dress in Purple Size: 2 Color: Purple

I need a function where I could extract the "Size:", but I only want 2 to come out for all. It's basically a description. I want to separate sizes from all my descriptions. Basically, I want a function that can help me determine the size from the description string.

**djapigo** · 10-15-2012, 06:19 PM

If your string is on cell A1, then try this formula...

=MID(A1,SEARCH("Size",A1)+15,SEARCH(" ",A1,SEARCH("Size",A1))-SEARCH("Size",A1)-15)

It's not pretty, but it just might work...

**aznj50** · 10-15-2012, 07:14 PM

it didn't work. ughh. It's in column F2 though, i replaced all the A1 with F2 still didn't work.

**aznj50** · 10-15-2012, 07:22 PM

"Victorian Ruffles Princess Dress in Purple Size: 2 Color: Purple" is the text and only want the size to come out from the result forumula.

**FDibbins** · 10-15-2012, 07:45 PM

if there will always be a ; in front of the number and < after it, try this ugly beast...
=MID(F1,SEARCH(";",F1,1)+1,SEARCH("<",F1,SEARCH(";",F1,1))-SEARCH(";",F1,1)-1)

this will allow for 2 or 20 or 200 etc

edit:
looking at your last post - are youy saying now that all the control codes are NOT in that text? then use this instead

=MID(F2,FIND(": ",F2,1)+1,FIND(" Color:",F2,1)-FIND(": ",F2,1))

**djapigo** · 10-15-2012, 07:46 PM

Oops, I took into effect the html code... HA!

If the string is on F2, then in G2, type this formula...
=VALUE(MID(F3,SEARCH("Size:",F3)+6,SEARCH("Color",F3,SEARCH("Size:",F3))-SEARCH("Size:",F3)-6))