Characters after the last space in a string
 

What excel formula (not VBA or macro) will give me the characters after the last space in a string?

Examples of cell contents:

3ABN Three Angels Broadcasting Network 9393
5-MAX 5StarMAX SAP 314
BBGL Bases Loaded/Buzzer Beater/Goal Line 403
MALL Mercury 86/123/220
JTV Jewelry Television 83/227
NBC (KNBC) 4
ABC (KABC) 7

Characters after the last space in a string
 

Hi,

Am Wed, 4 Mar 2015 11:32:41 -0800 (PST) schrieb gwc:

3ABN Three Angels Broadcasting Network 9393
5-MAX 5StarMAX SAP 314
BBGL Bases Loaded/Buzzer Beater/Goal Line 403
MALL Mercury 86/123/220
JTV Jewelry Television 83/227
NBC (KNBC) 4
ABC (KABC) 7

your data in column A:

=MID( A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)


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

Characters after the last space in a string
 

What excel formula (not VBA or macro) will give me the
characters after the last space in a string?

Something like this might work:
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",100)),100))

Characters after the last space in a string
 

Thank both of you.

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