Is there a formula to return a value bases on how certain text is written in a cell? For example
CELL A would have this IND2 Saucony 72units 6ctns ctn label and CELL B I would like to return 72 bases CELL A having units and CELL C I would like to return 6 based on CELL A having ctns
We cant resolve a pattern from one instance of test data, e.g. you could be wanting
the 2nd number in the text
or the number that begins the 3rd word
or something else.
Supply some more examples so a pattern may be determined.
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
If it always be XXunits and Xctns (with Special-K questions) these should work:
into B(1):
Formula:
Please Login or Register to view this content.
into C(1)
Formula:Please Login or Register to view this content.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks