Find & replace

[geert.van.ransbeeck]

Hello

I have datacells with different textdata. Each cell consists of 2
words. I want to cancel the first word in each cell. That first word
is not of the same length. How do I proceed?

 

[Mike H]

Hi,

To extract the last word

=MID(A1,FIND(" ",A1)+1,LEN(A1))

Drag down

Mike

 

[Gary''s Student]

With:
Hello World
in cell A1, in B1 enter:

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Niek Otten]

=RIGHT(A1,LEN(A1)-FIND(" ",A1))

 

[Stefi]

Maybe you will need to copy/pastespecial values from the helper column
containing formulae given by Mike and Gary"s Student back to the original
column.
Stefi


„[email protected]†ezt írta:

 

[David Biddulph]

=RIGHT(A2,LEN(A2)-FIND(" ",A2))

 

[MartinW]

Hi,

One more,

Try Data>Text to Columns and use space as the delimiter
and then delete the first column.

You could also go one step further in the Text to Columns wizard
and use the Skip column function.

HTH
Martin