View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gwc gwc is offline
external usenet poster
 
Posts: 62
Default 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