Forum Discussion

liverlarson's avatar
liverlarson
Brass Contributor
Sep 18, 2020
Solved

workbook and sheet name via formula

I have a standard header I put on almost every excel workbook I create I have been using for years. It includes several standard items, including Workbook name and Worksheet name, which are extracted...
excel
Excel for web
Formulas and Functions
office 365
  • SergeiBaklan's avatar
    SergeiBaklan
    Sep 18, 2020

    liverlarson 

    Afraid for Excel Online that's only with Office Script, there are properties getName both for workbook and worksheet.

     

    VBA and related functions don't work in Excel Online.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 17, 2024

Jan_Wijninckx 

Another variant

=@TEXTSPLIT( FORMULATEXT(D1), {"=","!","'"}, , 1)
Jan_Wijninckx's avatar
Jan_Wijninckx
Brass Contributor
Feb 19, 2024
🙂 Fantastic, thanks - however, MikeFromCanada wants a function that works for all versions. TEXTSPLIT is new since 31 Mar 2022.If one just works in O365 then this is beautiful.

Resources