I have a text String XXXXXXXX500XXXX and I pull out the 500 in a cell (E3) using Right and Left functions. I have the cell E3 formatted as a number but it will not sum. I understand if I copy and paste special - Value, it will then work. But is there a better way I am not seeing?

Thank you for your help