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?
|