Formula Help Request

macropod · #1 02-21-2013, 04:30 AM

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)

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

Quote:

Originally Posted by macropod

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)

Hi Paul
That worked perfectly.
Many thanks for your help.
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