New Posts For Thread: Excel Help Pleasehttps://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-pleaseI have a contact database in Excel format.In the phone field is a normal UK phone number. All numbers start with a 0. I need to delete that first number and replace it with 44.01234567890 will become 441234567890.It seems pretty simple but I cannot mThanks mate. Will do.https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708414#419708414Thanks mate. Will do.Sat, 16 Jan 2010 04:13:10 -0600I don't want anything for helping you out MOM - donate something to Haiti if you wish.https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708406#419708406I don't want anything for helping you out MOM - donate something to Haiti if you wish.Sat, 16 Jan 2010 04:09:16 -0600You are a diamond Ian. Received. If you have a Paypal account I will pop 20 quid over to you. Have a drink on me. Let me know on email. Thanks again mate.https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708402#419708402You are a diamond Ian. Received. If you have a Paypal account I will pop 20 quid over to you. Have a drink on me. Let me know on email. Thanks again mate.Sat, 16 Jan 2010 04:04:00 -0600Email senthttps://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708394#419708394Email sentSat, 16 Jan 2010 03:43:04 -0600Hopefully I will be able to use the edited version as a template?https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708390#419708390Hopefully I will be able to use the edited version as a template?Sat, 16 Jan 2010 03:11:26 -0600Thanks guys for all your help but I think this is beyond me.Would any kind soul edit it for me at http://whylose.com/help/1000.xls please? you will be rewarded in heaven. LOL.My email john at whylose dot com. The data is publicly available elsewherehttps://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708386#419708386Thanks guys for all your help but I think this is beyond me.Would any kind soul edit it for me at http://whylose.com/help/1000.xls please? you will be rewarded in heaven. LOL.My email john at whylose dot com. The data is publicly available elsewhereSat, 16 Jan 2010 03:07:43 -0600right clicck on the cell click on format cell change to numbers that will do it good luckhttps://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708382#419708382right clicck on the cell click on format cell change to numbers that will do it good luckSat, 16 Jan 2010 02:38:02 -0600Thanks Ian. I get ERR508. Any idea?https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708378#419708378Thanks Ian. I get ERR508. Any idea?Sat, 16 Jan 2010 02:35:57 -0600Insert a column to the right of the phone number.Copy the formula into the first cell of the new column. You will need to change "A1" to whatever cell if to the left. Copy the formula down the column.https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708374#419708374Insert a column to the right of the phone number.Copy the formula into the first cell of the new column. You will need to change "A1" to whatever cell if to the left. Copy the formula down the column.Sat, 16 Jan 2010 02:16:46 -0600Thanks Lori and Ian.Ian, where do I put =SUBSTITUTE(A1,"0","44",1)? Sorry, but I am a real novice at this.https://community.betfair.com/general_betting/go/thread/view/94082/23494610/excel-help-please?post_id=419708370#419708370Thanks Lori and Ian.Ian, where do I put =SUBSTITUTE(A1,"0","44",1)? Sorry, but I am a real novice at this.Sat, 16 Jan 2010 02:11:50 -0600