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.
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.
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.
Formula:Please Login or Register to view this content.
That will replace all spaces with empty strings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks