Combine 2 formulas

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)
 
P

Pete_UK

What do you want to get out of it in your example?

Should the A4 be A1 in the first formula?

Pete
 
K

Ken

sorry the formula should all read A1
the final result should read "ZB/B/15-2154 - ALL GOLD INDIAN TOMATOES DICED
12x410G"
 
R

Rick Rothstein

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.
 
K

Ken

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

Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Sum values on different rows 3
Conditional formula 3
CHANGE TEXT DATE TO NUMERIC DATE 5
exclude formulas when counting cells 3
Locking a cell reference in a formula 1
combine countif and sumproduct? 2
Sum of cells, where there are not errors in them 8

Top