View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nander
 
Posts: n/a
Default How to seperate 2 values to 2 different cells


In the examples below these values are in column B. I'd like the values
beyond the + sigh to move to the next cell. So B only contains
CA*F060*2* AND C contains G*V80905C

B
1 CA*F060*2*+G*V80905C**
2 CA*F060*2*+G*V81155C**
3 CA*F060*2*+G*V90905D**
4 CA*F060*2*+G*V950905D**
5 CA*F060*2*+G*V951155D**
6 CA*F060*2*+MBE1600


--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=536917