How to keep a space character at the end of a value (for barcodes)

[20GT]

Hi,
i loaded my .xls inventory file into excel to edit it and it auto removed all the spaces at the end of my barcode numbers.
I don't know why my inventory program uses spaces at the end of the barcode number but apparently it does
I'm trying to add the spaces back into the value, but as soon as hit the enter button it disappears again.

any suggestions to this? thanks

[20GT]

DUh i formatted the column as text works good now i hope will test it tomorrow

[Ace_XL]

Use in a separate column
=A2&" "
and drag down

Copy this entire column and paste special --values in Column A

Does this help?

[20GT]

when i (paste special --values in Column A), it pastes over the original values making both columns the same?

[FDibbins]

No, you need to copy the column with the formula to where you're original data is. so, if you're formula is in column C, then copy column C and past values to column A