Formula Help Request

Kevin@Radstock · #1 02-21-2013, 04:06 AM

Hi OTPM

Assuming your data is in A1, may be:

=LEFT(A1,FIND("+",A1)-3)&","&MID(SUBSTITUTE(SUBSTITUTE(A1,"SS",""),"SF", ""),FIND(",",A1)+1,LEN(A1))

Kevin

OTPM · #2 02-21-2013, 08:34 AM

Quote:

Originally Posted by Kevin@Radstock

Hi OTPM

Assuming your data is in A1, may be:

=LEFT(A1,FIND("+",A1)-3)&","&MID(SUBSTITUTE(SUBSTITUTE(A1,"SS",""),"SF", ""),FIND(",",A1)+1,LEN(A1))

Kevin

Many thanks for your response Kevin, I will try that.

Tony

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula help request	JAMS	Excel	2	04-06-2012 10:14 PM
Meeting Request Time Wrong	aimav	Outlook	0	03-26-2012 08:14 AM
Outlook Calendar request	steve42399	Outlook	2	04-12-2011 09:35 AM
Meeting Request - Another Organizer	coolpeter86	Outlook	0	12-12-2010 11:58 PM
Macro request: open on event	infotech	Outlook	0	12-08-2010 06:40 PM