CODEWITHSUNDEEP
excel
Kulikjak
Kulikjak

Reputation: 105

Excel - how to split cell with delimiter

i want to split the value of the excel cell in two values, but still have them only in one cell. I mean: i have cells with for example 40/50. Many of them. I want to count sum of numbers in front of / and the second sum of numbers behind /. Is it somehow possible without splitting those numbers in two different columns? thx

Upvotes: 1

Views: 298

Answers (1)

Dmitry Pavliv
Dmitry Pavliv

Reputation: 35863

If all your cells in range A1:A4 are in format x/y,

  • to sum all x use: =SUM(1*LEFT(A1:A4,FIND("/",A1:A4)-1))
  • to sum all y use: =SUM(1*RIGHT(A1:A4,LEN(A1:A4)-FIND("/",A1:A4)))

both formulas are array formulas, so you should press CTRL+SHIFT+ENTER to evaluate them.

enter image description here

Upvotes: 1

Related Questions