Hi all,

Does anyone know a formula that will move cells with certain text in them over to create a new column?

For instance, I have lots of rows with subject class names in them (I work in a school so the English classes are written like '7En2, 9En1', Math ones are written '7Ma2, 8Ma1') but the English and Math classes aren't all in the same column, they are mixed up. I need to move all the cells that are English classes into one column, and all Math into one. However I need them to stay on the same row that they are already in.

Does this make sense?

Thanks!