Jonathan Not sure about your second issue, but for the first, you could try messing about with Excel's LEFT and RIGHT functions. It's been a while since I used them in anger, but they basically allow you to identify a particular character in a cell by it's absolute position.
So, a sample function would go something like this. If you wish to identify say the second char in a cell, and do something based on its' value, your function would be something like: =IF(LEFT(A12,2)=1,A12,"*") I think this will, if placed in the cell next to A12, identify if the second char from the left in A12 is a 1 or not. It will then either return the same value of A12 if it is a 1, or insert a * character in the cell, allowing you to at least identify which numbers need to have the 1 inserted. There will also be a way, using the same function to automatically insert the 1 as necessary, in the correct place. However, as I say, it's been a while since I used Excel to this depth! Hope this helps. If I can think of a solution to your second conundrum, I'll drop you a line. You may be able to use these functions in a similar manner, but my logic is never strong on a Monday. Good luck! :-) P.S. Excel's help function is fairly good for these functions, I seem to remember. Kind regards Jonathan Brown browns photography Direct dial: +44 (0)191 285 7004 Mobile: +44 (0)7967 562 394 email: [EMAIL PROTECTED] web: <http://www.brownsphotography.com> > From: "Cavendish Studios" <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Sun, 15 Feb 2004 18:50:33 -0000 > To: "Prodig Main" <[EMAIL PROTECTED]> > Subject: [PRODIG] Any Excel Experts out there? > > 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 =============================================================== GO TO http://www.prodig.org for ~ GUIDELINES ~ un/SUBSCRIBING ~ ITEMS for SALE
