Spreadsheet formula compatibility with <br>?

[Mazen421]

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