| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell name
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Change cell name
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. "Pa Maher" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| How do I change a number in one cell to change a series of cells? | Excel Discussion (Misc queries) | |||
| excel deleting rows last cell does not change. How to change? | Excel Discussion (Misc queries) | |||
| Change workbook sheet reference using cell A1 to change a vairable | Excel Worksheet Functions | |||
Hybrid Mode
