Sheet name from range

[avi]

Hello,

I have a range address that contains the workbookName+SheetName. How
do I extract the sheet name only?

Certainly a trivial question...

Thanks
avi

 

[paul.robinson]

Hello,

I have a range address that contains the workbookName+SheetName. How
do I extract the sheet name only?

Certainly a trivial question...

Thanks
avi

Hi
Is the text in one cell?
How are the weorkbook and sheet names differentiated i.e. how do you
know where one starts and one finishes?
If there is a plus sign between them as in your example then

=RIGHT(A1,LEN(A1)-FIND("+",A1))

where your text is in cell A1, will find the sheetname.

regards
Paul