I am trying to create a simple macro to make creating a summary of the next days check ins and outs quick and easy. We export this information from our PMS to an excel spreadsheet and from there we delete rows/columns we don't need and arrange the columns like we want which is all pretty easy to make an automatic macro for. The only thing is when the information is exported the room #s come are in the format of "#12 Charming studio". We have specific names for all the rooms so they show up in the Room# column along with their room #. When we are finished arranging everything and send this to our housekeeping staff as a projection for the next days work we usually only include the digits "#12". So I want to take everything out except the number and the # symbol. This may seem simple yet there are sometimes cases when a guest books multiple rooms and thus in the exported file all rooms will be listed in the one cell so for example if they booked 3 rooms it can read "#3 vibrant apartment, #4 cozy studio, #6 quaint studio" all in one cell. In that case its okay if it has multiple numbers in the one cell as long as has deleted all the text description. I had a good code but it takes out all text ( including the # symbol) and it doesn't account for the multiple rooms situation so it will just display the first room number and not the other rooms they booked. I've tried to do it the long way with the search and replace searching all possible rooms names but i keep hitting a wall in the cases that it doesn't find the room name and thus won't complete the rest of the macro. Any idea how to do this? Thanks! ( P.S. i am kinda newbie when it comes to macro/ excel, VBA coding etc).