First time here? Check out the FAQ!

1 | initial version |

If, say, B2 is containing a formula just consisting of the equal sign and a reference into a different sheet, you can get the sheetname by standardfunctions as shown here:.

```
=SUBSTITUTE(MID(SUBSTITUTE(FORMULA(B2);"$";"");2;FIND(".";SUBSTITUTE(FORMULA(B2);"$";""))-2);" ";"")
```

If you can assure that there are no superfluous spaces and no $-character (absolute referencing) in front of the sheetname, you can use the much simpler formula:

```
=MID(FORMULA(B2);2;FIND(".";FORMULA(B2))-2)
```

2 | No.2 Revision |

If, say, B2 is containing a formula just consisting of the equal sign and a reference into a different sheet, you can get the sheetname by standardfunctions as shown ~~here:. ~~here:

```
=SUBSTITUTE(MID(SUBSTITUTE(FORMULA(B2);"$";"");2;FIND(".";SUBSTITUTE(FORMULA(B2);"$";""))-2);" ";"")
```

If you can assure that there are no superfluous spaces and no $-character (absolute referencing) in front of the sheetname, you can use the much simpler formula:

```
=MID(FORMULA(B2);2;FIND(".";FORMULA(B2))-2)
```

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.