Spreadsheet formula compatibility with <br>?

[Mazen-AG]

Is your feature request related to a problem? Please describe.
I am trying to make a budget sheet to document my months spending
I am using
to add new lines inside the cells so I can type all I spent that day

But this causes an issue with the spreadsheet formula making it not give me any output

Describe the solution you'd like
Is there a way to make a workaround for this so it ignores the
and extract just the numbers out of it?

Describe alternatives you've considered
I considered remaking the entire table in another format so I can use spreadsheet formulas, but this will make the table so so wide

Additional context
I am aware that is probably too much work for what seems to be not much but I was curious if this is possible or not.
If it is passible maybe it is worth implementing and maybe I would write up some spaghetti code to make it work