View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default multiple values in one cell

You can split up a string of numbers in a cell separated by a common
character ( in your case the plus sign) by using Text to Columns:

1. select the cell(s)
2. pull-down Data Text to Columns... and select Delimited and pick the
plus sign
3. the individual numbers will become separated, each in its own cell.
--
Gary's Student


"Caleb" wrote:

I am trying to find a way to pull multiple values from one cell
(A1=12.35+23.56+43.73), into seperate cells on another sheet, B2=12.35,
B3=23.56, B4=43.73. Any help would be greatly appreciated. Thank you.