Please, I will like to know how to serially append numbers within a cell. For example: I'm trying to create codes to link to assets in a hotel. So, I go like this RM101/BED/001 RM102/BED/002 RM103/BED/003 RM104/BED/004 RM105/BED/ RM106/BED/ Now, I could have dragged it down to number it serially, but that will change the Room numbers (RM 101, RM 102...). So, I'll like to know the best way I can number the rooms serially without changing the room numbers. Thanks a lot.
