Subtracting text
"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
=left(A1,len(A1)-len(B1))
|