Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert Leading Characters If String Is Only 7 Characters	Paperback Writer	Excel Discussion (Misc queries)	2	April 21st 09 09:07 PM
Put A Space Between 2 right characters	carl	Excel Worksheet Functions	3	April 8th 08 05:08 PM
cHARACTERS BEFORE THE SPACE	T De Villiers	Excel Worksheet Functions	3	January 19th 06 01:22 AM
Characters before the space	T De Villiers[_8_]	Excel Programming	3	January 18th 06 10:22 PM
erase all space characters into string	Maileen[_2_]	Excel Programming	4	January 16th 05 09:10 PM

All times are GMT +1. The time now is 05:47 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us