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
Toppers - 13 Jun 2007 21:35 GMT
=MID(A1,7,255)
assuming "text" starts in position 7 i.e. "ABCD -" are first 6 characters
> Hi again!
>
[quoted text clipped - 6 lines]
> Thanks,
> Shannon
Shannon - 13 Jun 2007 22:19 GMT
Thank you so much!
> =MID(A1,7,255)
>
[quoted text clipped - 10 lines]
> > Thanks,
> > Shannon