Very true Bob. A much better solution, but regrettably the OP has since
posted to say he wanted to extract the word, not omit it so he has used the
LEFT function.

Regards

Roger Govier


Bob Miller wrote:
or =RIGHT(A1,LEN(A1)-FIND(" ",A1)). It doesn't care how many characters
there are in A1.
Roger Govier Wrote:

Hi
Presumably there is a space between the words. If so, then in another
column
=MID(A1,FIND(" ",A1)+1,255)
Change the 255 if necessary, i.e. if there are likely to be more than
255
characters after the first space.

Regards

Roger Govier


Bhupinder Rayat wrote:
Hi all,

I have a column of cells containing text strings, and I want to omit
the
first word from each cell, which are of varying character lengths. I
can do
it the long winded way using a combination of the text functions (i.e.
left,
mid etc..), but is there a quicker way to omit the first word? The
character
lengths of the first word vary from 4 to about 9 characters. I have
over
10000 cells to check.

Any help would be much appreciated.

Regards,


Bhupinder Rayat