How to search a cell for specific information and to pull out that figure found !

[Dave T]

Okay , this maybe a tough one....but I hope its solvable , basically I am
uploading products to one of the more popular websites , they have various
columns , one of which is comment , in this I can type in up to 1000
characters but cannot contain "<" or ">"



The comment section I would like to be able to add at the end something like
(min=6.75) , this would be my min selling price.



There system allows you to download a re-pricing report, it shows only items
where you are not the lowest price, but it's a mix of various products all
have various min sell prices, so to make it quick, it would be great if I
can set up a cell, to look at my comment and find the (min=6.75) and for it
to use that figure with a few other standard formulas to work out how much I
can sell it for or need to drop my price to .



So basically I just need to pull the 6.75 out of my comment, is this
possible.



If I have not explain this very well, please ask me to offer further
details, I presume it's possible, but I'm unsure how to.



Below is one of my comments, I have added the extra part of (min=6.75) so
you can see what I mean.



BRAND NEW Factory Sealed Product Dispatched Same Day if ordered before 3pm ,
Release. Delivery is 2 - 3 working days from order by Royal Mail.(min=6.75)

 

[Pete_UK]

If you want to find the location of a particular character (eg =) in a
string in A1, you can use:

=SEARCH("=",A1)

If you have the string "(min=6.75)" in A1, then the formula will
return 5, as "=" is the 5th character in the string. You can combine
this with MID to get the number from the string, i.e.:

=MID(A1,SEARCH("=",A1)+1,LEN(A1)-SEARCH("=",A1)-1)

This will extract 6.75 from your example comment. This is a text
representation of the number, so if you want a pure number then you
can put VALUE(...) around it, or multiply it by 1.

Note that there must only be one equals sign in the string, and it
assumes that you have a single character after the number (the closed
bracket).

Hope this helps.

Pete

 

[Dave T]

Pete , Thank you very much , that worked a treat , i do have one more , i
hope i'm not taking the biscut by asking for more help , can i ask is your
email address valid ? or would you prefere i post the question into the
newsgroup ?

thanks again.

 

[Pete_UK]

You can email me at:

pashurst <at> auditel.net

Pete