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

Count Number of Unique Cells That Don't Have Certain Characters 0
Referencing the values of multiple cells in conditinal formatting. 0
How do I combine/join multiple formulas 2
Function to Combine Names and Middle Initital In Various Formats 3
Varying cell ranges in formulas according to number of cells with certain value 1
Combine text from multiple cells into one cell - =(A1&","&A2","&A3 5
Combing a V Lookup result with ("00"&A2)*1 in same formula 4
combine three if functions 3

Top