how to delete or extract specific info from large numbers of cells.

[kmartin888]

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

[6StringJazzer]

This could be done by a formula, or by a macro. The problem is difficult because of your data design. The correct way to store this information would be to use five rows, instead of one row.

This formula will isolate the fourth line. There may be a shorter one but this works.

=LEFT(MID(SUBSTITUTE(A1,CHAR(10),"~",3),FIND("~",SUBSTITUTE(A1,CHAR(10),"~",3))+1,99),FIND(CHAR(10),MID(SUBSTITUTE(A1,CHAR(10),"~",3),FIND("~",SUBSTITUTE(A1,CHAR(10),"~",3))+1,99))-1)