I'm trying to create a flat database in Excel to list all my books.The problem is how can I create a function that takes care of the ISBN numbers that books have? Sometimes they have 9 digit numbers, sometimes 10 or even 13 numbers. I need a function that looks in a column that has unformatted numbers and then takes the MID function to convert them into strings and then CONCATENATE them into their appropriate number format like 0-0000-9999-9. It seems that simply formatting the column using custom format doesn't work.
A1 is Title.
B1 is Year
C1 is Format
D1 is where I list the unformatted ISBN number.
E1 is the function that looks in D1 and uses the MID and CONCATENATE to create the appropriate ISBN number regardless if it's 9 digit, 10 digit or 13 digit.
Can anybody create a sample function that does this? Thanks in advance.
Bookmarks