Try this

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

This would give you the sheet name exactly as the matter in the cell.
--
Thanks
Suleman Peerzade


"des-sa" wrote:

hi, i have 2 questions.
1. how do i give a sheet the same name as a cell entry in that sheet?
2. then when i enter the =now() formula, the date in that cell is kept as
the current date. is there a way to automatically convert the formula to a
number as soon as the date has been entered or in any other way?
thanks