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

=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

Thank you so much!

"Toppers" wrote:

=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