delete first two words in a cell

F

flashing frank

woow thanks for the fast replies :)

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

greetz
f
 
R

Ron Rosenfeld

woow thanks for the fast replies :)

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

greetz
ff
Click to expand...

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
 
Top