I would like to know if there is a way to selectively delete specific information from individual cells within a large worksheet.

the worksheet in question is a schoolwide teacher schedule. each row is a different teacher and each column represents a period of the school day.
each cell contains the class code, the class name, the teacher name, room number and which days of the week they meet.

the information I need to keep is the room number which is line 4.

In the past, I have gone through and retyped each and every cell. it would be helpful in the future to be able to just extract the information that I need

any help would be greatly appreciated.

thanks,
Keith

I have included a small snip from my personal schedule but have excluded any other info for confidentiality purposes.excel snip.JPG
snip2.JPG