Hi, a complete excel newbie here on his third day at his first job.

Hey everybody,

I'm new here and I'll be visiting this forum a lot because this new job I got requires me to do a lot of excel work.

Anyways, here's the question.

I have 120 cells in a row which basically looks like this...

Stack Chairs - 2nd Floor Warehouse (1/122)
Stack Chairs - 2nd Floor Warehouse (1/122)
Stack Chairs - 2nd Floor Warehouse (1/122)
Stack Chairs - 2nd Floor Warehouse (1/122)
Stack Chairs - 2nd Floor Warehouse (1/122)



Is there anyway I could just change the numbers in order without changing the texts?
I already asked my supervisor and he basically told me that it's impossible because once the cells are written in texts it will only read as texts.



Thanks in advance !

Thank you for the quick response.

Unfortunately this is in D column and I'm about 700 down.
Columns A-K are all full of information and I can't have random numbers showing on the report..

and yes! I tried to change the title but I don't think I can. Thanks for the tip anyways !

Thank you for the quick response.

Unfortunately this is in D column and I'm about 700 down.
Columns A-K are all full of information and I can't have random numbers showing on the report..

and yes! I tried to change the title but I don't think I can. Thanks for the tip anyways !

You can insert a column to store the numbers and then hide it so it's not visible. Right click on any column title for "insert" and "hide" options.

Originally Posted by Speshul

Simply adjust the formula

="Stack Chairs - 2nd Floor Warehouse ("&B1&"/122)"
And put the numbers in another column somewhere

Or, try this

="Stack Chairs - 2nd Floor Warehouse ("&ROW(1:1)&"/122)"

Start with the first row, and just copy that formula down and it will increment for you

This worked like a charm.

Thank you Speshul.

Btw the method you suggested where you hide the columns doesn't really work well for me.

the number part the actual numeric part is just blank... so you only see this (/120)