| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter Range on Sheet B Based on List on Sheet A | Excel Discussion (Misc queries) | |||
| How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
| HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Discussion (Misc queries) | |||
| HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Programming | |||
| HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Worksheet Functions | |||
Hybrid Mode
