This is not strictly 'on-list' except as far as it relates to marketing - something all photographers have to do. List Mum - please bear with me since I only have the List to access a large range of skills quickly.
Any replies should perhaps be off-list! I need to clean up around 10,000 phone numbers on my client database so that: The second digit in the string is always a '1'. Many years ago, numbers here in the UK had an additional digit '1' added. I, therefore, have most numbers with the '1' in place but still a good many without. Is there any way Excel (where I have imported the list) can be programmed to scan a column of numbers and add a number '1' as the second digit where one does not already exist? I also need to remove any '-' (hyphens) and spaces from the numbers so that I am left with a continious string with no breaks. Again, is there any way of setting ip Excel to do this? I can do both things manually, but I reckon that, at best, it will take me 12 hours + and a lot of neck-ache!! I have to do this because I use software that can screen numbers in the new form and I need to use it to remove previous clients who just didnt spend, from being approached again. Any help would be greatly appreciated, including the addresses of any non-photographers that might be able to help. Thanks, Jonathan Coleman Chester UK =============================================================== GO TO http://www.prodig.org for ~ GUIDELINES ~ un/SUBSCRIBING ~ ITEMS for SALE
