i need the sheetname in my cells

[Kiklop]

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?

 

[Biff]

Don't know if it's any better:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1

Biff

 

[Kiklop]

That means that the sheetname is available only with the CELL function?

Don't know if it's any better:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1

Biff

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?

 

[Biff]

Well, you could get it with a VBA user defined function but why would you if
there is a built-in function.

Biff

That means that the sheetname is available only with the CELL function?

Don't know if it's any better:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1

Biff

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?

 

[Kiklop]

Thank you.

Well, you could get it with a VBA user defined function but why would you
if there is a built-in function.

Biff

That means that the sheetname is available only with the CELL function?

Don't know if it's any better:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1

Biff

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?

 

[Biff]

You're welcome!

Biff

Thank you.

Well, you could get it with a VBA user defined function but why would you
if there is a built-in function.

Biff

That means that the sheetname is available only with the CELL function?

Don't know if it's any better:

=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)*1

Biff

I am using numbers for sheetnames and I need them in a cell in this way
=VALUE(RIGHT(CELL("filename";A3);2))
Is there any another way to put the sheetname into the cell?