Myrna Larson

Posts: n/a

Find last space from the right of text

=MID(SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))),FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,255)

On Mon, 24 Jan 2005 09:49:02 -0800, "Michael"
wrote:

I need to find the last space from the right of text in a cell and then
return the text that is to the right of that last space.

Any help is greatly appreciated.

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
how to find replace text or symbol with carriage return	jo	New Users to Excel	11	April 4th 23 10:41 AM
Excel has a "Find Next" command but no "Find Previous" command.	Michael Fitzpatrick	Excel Discussion (Misc queries)	2	January 10th 05 11:45 PM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM
how to hyperlink text to a cell	steve	New Users to Excel	1	December 14th 04 08:21 PM
Macro or Function to make text size to suite text Length?	lbbss	Excel Discussion (Misc queries)	4	December 14th 04 07:53 PM

All times are GMT +1. The time now is 03:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us