How to remove the spaces between credit card numbers?

[anirta]

Hi,

How can I remove the spaces between the credit card numbers for uploading into a database that only has 16 characters?

Thank you very much.

[Paul]

Wow, this is the second new thread I've seen today where users are wondering how to work with credit card data IN EXCEL - one of the least secure methods to store data in existence (it would be safer written on paper in a locked box under your floorboards).

Please note: If you are storing credit card numbers in Excel, STOP IMMEDIATELY and find another secure method to do so. Whether it's through your bank or an payment processor, other methods are out there. Even in a database, if it's unencrypted and not secured extremely well, you're risking huge legal and financial penalties.

As for removing spaces (or any character) from any text string, you can use the SUBSTITUTE function, e.g.

Please Login or Register  to view this content.

That will replace all spaces with empty strings.