Menu

Help with Excel Formula?

Search this Thread

Prev

Previous Post

Next Post

Next

#7

Report Post

Posted to microsoft.public.excel.misc

Victor Delta[_2_] Victor Delta[_2_] is offline

Victor Delta[_2_] is offline

external usenet poster

Posts: 199

Default

Help with Excel Formula?

In article , says...

Hi Victor,

Am Sat, 15 Aug 2015 09:40:08 +0100 schrieb Victor Delta:

Many thanks, that's very helpful. I was hoping it might be possible to
make the split on the last (of n) spaces to cope with the 'Cllr Peter M
Smith' who may crop up one day...!

to find always the last part of the string try:
=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN(SUBSTITUTE(A1," ",))))+1,99)

Regards
Claus B.

Claus

Thanks again,

V

Reply With Quote

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
Excel Formula Guidance. Formula need to determine if cell is popul	Matt	Excel Programming	0	February 19th 10 07:32 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible	blue[_2_]	Excel Discussion (Misc queries)	2	July 11th 07 06:08 PM
Build excel formula using field values as text in the formula	val kilbane	Excel Worksheet Functions	2	April 18th 07 01:52 PM
Excel Formula Doesn't Execute (Shows formula-not the calcuation)	Keys1970	Excel Discussion (Misc queries)	4	November 15th 06 02:12 PM
Excel 2002 formula displayed not value formula option not checked	Dean	Excel Worksheet Functions	1	February 28th 06 02:31 PM

All times are GMT +1. The time now is 02:45 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement