Formula Help Request

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help Request

FAQ

Thread Tools

Display Modes

02-21-2013, 08:34 AM

OTPM

Windows 7 32bit Formula Help Request

Office 2010 32bit

Expert

Join Date: Apr 2011

Location: West Midlands

Posts: 981

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:36 AM.