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.