Thread: Find & replace
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default Find & replace

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

=RIGHT(A1,LEN(A1)-FIND(" ",A1))
--
Gary''s Student - gsnu2007k


" wrote:

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?