Formulas
=MID(A1,7,255)
assuming "text" starts in position 7 i.e. "ABCD -" are first 6 characters
"Shannon" wrote:
Hi again!
I was wondering how I could take the text "ABCD -Text" (in one cell) and
create a formula in another cell so that only "Text" would show up and not
the "ABCD -". The problem so far is that the "Text" is not always the same #
of characters so the RIGHT function will not work.
Any help would be greatly appreciated!
Thanks,
Shannon
|