Naming worksheets based on cell values

Is it possible to extract a cell's value and have that be the worksheet name?

TIA!

You can use a macro to do that:

Please Login or Register  to view this content.

Just change the A1 to the cell you want to extract.

Worked like a charm, but when I tried to do this:

Please Login or Register  to view this content.

it did not work. Is it possible to use two different cells to name a sheet?

Thanks!

Try splitting them up:

Please Login or Register  to view this content.

Pure & simple genius. Thanks so much, I appreciate it!

Glad I could help.