Deleting first word in cells 1

[kwuk]

Hi,

I have a excel spreadsheet in which each cell has information i want to keep, except for the first word in each cell which i want deleted.

i.e.

'An example cell' - I would want the word 'An' removed.

The word in each cell is different in each cell, so i cant just simply delete any instance of any particular one.

Any ideas how I can do this?

Thanks

 

[marplot]

Convert the Column containing data to Columns using "text to columns" - with space as a delimiter.
Delete the first column after the event, then re-concatenate format like B1&C1&D1 [and so on down the column] afterwards, copy it onto itself as "Values" and delete the working columns.

 

[PHV]

As we are in VBA forum, you may play with something like this:
For Each c In YourRangeOfInterest
a = Split(c.Text)
a(0) = ""
c.Text = Join(a)
Next c
If your version of Excel don't like Split/Join functions, you may consider InStr and Mid.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[kwuk]

Excellent! And so simple too. I had never seen the text to columns feature before.

Have a star.

 

[kwuk]

Thanks to PHV also, that could come in handy for future use.