unable to sum/ calculate copied data from ERP or mail

=CHAR(160) When you use this function in a cell, it will return a non-breaking space, which is a special type of space that is used to prevent a line break at that point in the text. This can be useful for formatting cells that contain long text strings or for aligning text in a specific way. You can use this function in a formula or directly in the cell. It's also important to note that you can use the ALT + 0160 to insert the non-breaking space in the cell.