Sheet name from range
 

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

Sheet name from range
 

On Nov 20, 5:52 pm, avi wrote:
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