View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frosty 1234 Frosty 1234 is offline
external usenet poster
 
Posts: 3
Default Remove Characters Until a Specific Character is Reached

This was exactly what I needed - worked great - Thanks,
--
Thanks so much


"David Billigmeier" wrote:

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

--
Regards,
Dave


"Frosty 1234" wrote:

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...
--
Thanks so much