Hi all,
I need a function that will replace all letters in a given cell with the number "0" and if the string of digits is shorter than seven digits then 0's need to be added to get it up to 7 digits. Basically, invoices are received that need to have a seven digit invoice number but they are often received with between 4-7 characters that are alpha-numeric. It would save me loads of time to not have to change these invoice numbers individually!
I was thinking of simply using a find and replace function but I'm not sure how I could FIND all alphabetical characters other than but nesting twenty seven different FIND functions, which isn't exactly efficient.
Let me know if you need any more info or have any other questions!
Thank you in advance!
I need a function that will replace all letters in a given cell with the number "0" and if the string of digits is shorter than seven digits then 0's need to be added to get it up to 7 digits. Basically, invoices are received that need to have a seven digit invoice number but they are often received with between 4-7 characters that are alpha-numeric. It would save me loads of time to not have to change these invoice numbers individually!
I was thinking of simply using a find and replace function but I'm not sure how I could FIND all alphabetical characters other than but nesting twenty seven different FIND functions, which isn't exactly efficient.
Let me know if you need any more info or have any other questions!
Thank you in advance!