View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Characters after the last space in a string

Hi,

Am Wed, 4 Mar 2015 12:05:19 -0800 (PST) schrieb gwc:

Thank both of you.


you are welcome
Here is another suggestion:
=MID(A1,MAX((MID(A1,COLUMN(1:1),1)=" ")*COLUMN(1:1))+1,99)
Insert this formula with CRTL+Shift+Enter


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional