View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gilbert DE CEULAER Gilbert DE CEULAER is offline
external usenet poster
 
Posts: 25
Default How can I extract the second half of addition ?

I have lots of entries that have the form "+6+2", "+4+3", "+5+1".
Is there any way to extract the second half, so the "+2", "+3", "+1" - part
?
(Not all of the entries concerned are like that; somre simply read "+6",
"+3", "+2"; in that case the extraction should read "0")
Thanks in advance,
Gilbert