delete first two words in a cell

F

flashing frank

hi,
can someone tell me how i manage to delete the first two words in
cell?

eg.
July 24: info prodid4775 gorass andreas
-should become-
info prodid4775 gorass andreas

or is it possible to extract every word beginning at the third one?

i was playing around with some code i found at excel tip:
=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))

it is supposed to extract the first word of A1.
for some reason i only get an error message.
i am working with excel 2002.

hope someone can help me out

greetz
f
 
T

Trevor Shuttleworth

If it is always a date followed by a ":", search for the position of the ":"
and add 2 to give the start of the text and use the MID or RIGHT function to
extract the data.

Regards

Trevor
 
G

Gord Dibben

ff

If format always the same, you could try Data>Text to Columns>De-limited by
":" to break into two separate cells.

Gord Dibben Excel MVP
 
R

Ron Rosenfeld

hi,
can someone tell me how i manage to delete the first two words in a
cell?

eg.
July 24: info prodid4775 gorass andreas
-should become-
info prodid4775 gorass andreas
Click to expand...


=MID(A1,1+FIND("~",SUBSTITUTE(A1," ","~",2)),255)


--ron
 
Top