Moving Certain Cells To a New Column

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!

Originally Posted by akhileshgs

It can be done with macro only. not with formula... Will you be ok to use that?
And it will be easy to understand if you can upload a sample file.

I have no experience of using Macro but I can give it a go...

Any chance you could give me some tips at all?

I have no experience of using Macro but I can give it a go...

Any chance you could give me some tips at all?