Combine 2 formulas

  • Thread starter Thread starter Ken
  • Start date Start date
K

Ken

I have the following in cell: A1
"Item : ZB/B/15-2154 - ALL GOLD INDIAN TOMATOES DICED 12x410G Stock On
Hand : 6"

how do I combine the following 2 formulas into 1 formula

1) =RIGHT(A1,LEN(A4)-SEARCH(":",A1))
2) =LEFT(A1,SEARCH("stock",A1)-1)
 
What do you want to get out of it in your example?

Should the A4 be A1 in the first formula?

Pete
 
sorry the formula should all read A1
the final result should read "ZB/B/15-2154 - ALL GOLD INDIAN TOMATOES DICED
12x410G"
 
My guess is you are looking for this...

=TRIM(MID(LEFT(A1,SEARCH("stock",A1)-1),FIND(":",A1)+1,99))

where I am assuming your text will never be longer than 99 characters... if
it will, just change the 99 to the maximum number of characters there can
be.
 
Spot on thanks

Rick Rothstein said:
My guess is you are looking for this...

=TRIM(MID(LEFT(A1,SEARCH("stock",A1)-1),FIND(":",A1)+1,99))

where I am assuming your text will never be longer than 99 characters... if
it will, just change the 99 to the maximum number of characters there can
be.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Converting from Decimal to Base-36 in Excel Formula 8
Conditional formula 3
Sum values on different rows 3
testing for left 2 characters in set of 3 choices 5
Help Creating Excel Formula 4
is this possible 3

Back
Top