Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Characters after the last space in a string
Thank both of you.
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Leading Characters If String Is Only 7 Characters | Excel Discussion (Misc queries) | |||
Put A Space Between 2 right characters | Excel Worksheet Functions | |||
cHARACTERS BEFORE THE SPACE | Excel Worksheet Functions | |||
Characters before the space | Excel Programming | |||
erase all space characters into string | Excel Programming |