I need to mass delete or split text from columns with different content

Hi,

I need help with deleting or splitting words using one word as a reference and deleting everything from this word. For example

Column C

I have worked at this desk

Never tried cooking at your house


What I want to do is to delete every single word that comes after "at", as all my rows will have the word "at" followed by different lines of text, so what I want it to be is either:

Column C

I have worked

Never tried cooking

Or splitting them like this:

Column C

I have worked

Never tried cooking


Column D

this desk
your house


Any help? Thanks!

How about

Please Login or Register  to view this content.

@dotchiejack
What happens if the cell contains "Today is Saturday"

Hi Fluff13, thanks for the reply. Is this a Macros formula to be insterted in teh developers portal and saved as such? I am wondering how do I trigger it.

Yes, it needs to go in a regular module. In the VBE click Insert > Module > then paste the code into the new window.
You can run it from Xl by Alt+F8 > select the macro > Run