Change cell name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to change the name of a cell without deleting it and renaming
it?

The reason I ask, I have cells named "Comment1" to "Comment20". I will be
adding more. It would be better if comment 20 came after comment 19 rather
than before comment 2.
 
You could try inserting a new column where you would have the following
formula:
=MID(A1,8,250); this is assuming that all of your comments start with the
word comment. Then all you have to do is sort by the column where the formula
is and hide it if you dont want the user to see it.
Note that I am using a1 as the cell where the word comment appears, change
it as you will.

If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find wildcard text between {} cut, and paste in another cell 8
Excel Import Comments 3
Track Cell Changes 1
Question regarding comments 2
#NAME? 5
sum accross worksheets using names 1
Moving Parsed Text from Rows to Columns 3
Is there a way to enter a comment on a locked cell in Excel? 1

Back
Top