"Max" wrote:
Try in C1: =SUBSTITUTE(A1,B1,"")

Test with "time to time" in A1 and "time" in B1.


----- original message -----

"Max" wrote in message
...
Try in C1: =SUBSTITUTE(A1,B1,"")
voila? celebrato, click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"idrabefi" wrote:
Can anyone offer help subtracting the contents of 1 cell's text from
another?
This is basically a reverse =CONCATENATE() question.

Ex: Cell A1 = ABCDEFG
Cell B1 = FG
formula results desired for A1-B1 = ABCDE