View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] staeri@gmail.com is offline
external usenet poster
 
Posts: 35
Default How to find values in string? - Urgent!

I have a cell containing for example:

Cell A1: -7 / +18 (%)
Cell A2: -4.5 / +3.5 (pts)

I want to break out the two values into separate cells, for example:
Cell A2 = -7, Cell B2 = 18
Cell A3 = -4.5, Cell B3 = 3.5

Can someone please tell me how?

Regards,

S