4

I have some cells with text like

1200 1200 1400

And I would like to get the sum of the numbers in another cell. I think it is impossible to do using an excel formula since there is no loop, but I may be wrong. For example, I can get a string with a formula using =CONCATENER("=";SUBSTITUE(P25; " ";"+")) (sorry, I use Excel in French), but I cannot evaluate it.

Labo
  • 203

1 Answers1

1

No, you can't use one formula for this. Either use VBA or do something like

="="&SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),"+"),CHAR(10),"+")

Then copy - paste special - paste values, then edit the cell and press enter. That's the quickest I can figure out as INDIRECT() won't work.

Raystafarian
  • 21,963
  • 12
  • 64
  • 91