Works for me as written

qwerty asdfgh in A1

=RIGHT(A1,LEN(A1)-SEARCH(" ",A1)) in B1 returns asdfgh

Maybe you have missed something in your tyoing?

Try copy/paste from here.

Another method you may want to try is DataText to ColumnsDelimited by space.


Gord Dibben MS Excel MVP


On Thu, 19 Jul 2007 08:08:08 -0700, Libby
wrote:

I am trying this formula and it tells me that I have too few arguments. what
am I doing wrong.