delete first two words in a cell

[flashing frank]

woow thanks for the fast replies

special thanks to
Ron Rosenfeld : your function is exactly what i was looking for

greetz
f

 

[Ron Rosenfeld]

woow thanks for the fast replies

special thanks to
Ron Rosenfeld : your function is exactly what i was looking for

greetz
ff

Thank you for the feedback. Glad to help. Please note that the function
assumes that there is only a single <space> between words.

If multiple spaces between words are possible, then the string should first be
TRIMmed.

Something like:

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