View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Oleg
 
Posts: n/a
Default How to get values separated with /


For example,
I have a values separated with / in A1 cell
58555/55665
In result I want to get a value before / in A2(58555) cell and value
after / in A3 cell (55665)


--
Oleg


------------------------------------------------------------------------
Oleg's Profile: http://www.excelforum.com/member.php...fo&userid=4004
View this thread: http://www.excelforum.com/showthread...hreadid=520592