Remove Characters Until a Specific Character is Reached

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have cells with First Last names in them - need last name only. How to delete
all characters up to and inlcuding the first blank space from left to right.
I am having difficulty because the length of the first name varies...
 
Thu, 17 May 2007 10:26:04 -0700 from Frosty 1234 <Frosty1234
@discussions.microsoft.com>:
Have cells with First Last names in them - need last name only. How to delete
all characters up to and inlcuding the first blank space from left to right.
I am having difficulty because the length of the first name varies...
Click to expand...

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

This will fail if you have any middle names, but it will work with
two-word last names like "de Souza".
 
Tried this too and works as well - except of course on those with middle
names. Really appreciate the fast response.
 
I am trying this formula and it tells me that I have too few arguments. what
am I doing wrong.
 
Post the *exact* formula you are trying.

Here's another way to do the same thing:

=MID(A1,FIND(" ",A1)+1,255)
 
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 Data>Text to Columns>Delimited by space.


Gord Dibben MS Excel MVP
 
Back
Top