Formula Help Request

		Microsoft Office Forums > Microsoft Excel > Excel
Formula Help Request

FAQ

Thread Tools

Display Modes

02-21-2013, 04:30 AM

macropod

Windows 7 64bit Formula Help Request

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 21,963

Hi Tony,

Since you can have + or - and a variable string from there till the first comma, try:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(H2,MID(H2,IF(ISE RROR(SEARCH("+",H2)),SEARCH("-",H2),SEARCH("+",H2)),SEARCH(",",H2)-IF(ISERROR(SEARCH("+",H2)),SEARCH("-",H2),SEARCH("+",H2))),""),"F",""),"S","")
(delete unwanted spaces inserted by the board software)

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

« 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 12:43 PM.