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 !
Bookmarks