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

"Mike H" wrote:

The formula refers to A4. what's in that cell?

"Ken" wrote:

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(A1)-SEARCH(":",A1))
2) =LEFT(A1,SEARCH("stock",A1)-1)