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
|