Yeah, left(cell, a1) was wrong. On Fri, Oct 14, 2011 at 10:12 AM, Kevin Lundy <[email protected]> wrote:
> =IF(LEFT(A1,1)="0",A1,"0"&A1) > > Just tried it. Works > > On Fri, Oct 14, 2011 at 10:08 AM, Oliver Marshall < > [email protected]> wrote: > >> Adjusting that for the right cell number, I just get #NAME! appear. **** >> >> ** ** >> >> Thanks anyway though**** >> >> ** ** >> >> * * >> >> *From:* Jonathan Link [mailto:[email protected]] >> *Sent:* 14 October 2011 15:04 >> >> *To:* NT System Admin Issues >> *Subject:* Re: [OT] Quick excel question**** >> >> ** ** >> >> if(Left(cell,a1)="0",a1,"0"&a1)**** >> >> On Fri, Oct 14, 2011 at 9:59 AM, Oliver Marshall < >> [email protected]> wrote:**** >> >> Anyone know how to replace a number in a cell but only if it occurs at the >> start of the cell?**** >> >> **** >> >> I have a column of phone numbers (01234 etc). Each **should** start with >> a 0 however some have the 0 missed off and start with a number. In order to >> import these I need to insert a 0 at the start of the cell of those cells >> that start with a number that isn’t 0…if that makes sense.**** >> >> **** >> >> Olly**** >> >> **** >> >> **** >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to [email protected] >> with the body: unsubscribe ntsysadmin**** >> >> ** ** >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to [email protected] >> with the body: unsubscribe ntsysadmin**** >> >> >> >> >> >> Network Support >> Online Backups >> Server Management >> >> Tel: 0845 307 3443**** >> >> Email: [email protected] >> >> Web: http://www.g2support.com**** >> >> Twitter: g2support <http://twitter.com/home?status=@g2support>**** >> >> Newsletter: http://www.g2support.com/newsletter**** >> >> Mail: 2 Roundhill Road, Brighton, Sussex, BN2 3RF >> >> **** >> >> **Have you said something nice about us to a friend or colleague ? ** >> >> **Let us ****say thanks. Find out more at www.g2support.com/referral** >> >> ** ** >> >> G2 Support LLP is registered at Mill House, 103 Holmes Avenue, HOVE**** >> >> BN3 7LE. Our registered company number is OC316341. **** >> >> ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ >> ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ >> >> --- >> To manage subscriptions click here: >> http://lyris.sunbelt-software.com/read/my_forums/ >> or send an email to [email protected] >> with the body: unsubscribe ntsysadmin >> > > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ > ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ > > --- > To manage subscriptions click here: > http://lyris.sunbelt-software.com/read/my_forums/ > or send an email to [email protected] > with the body: unsubscribe ntsysadmin > ~ Finally, powerful endpoint security that ISN'T a resource hog! ~ ~ <http://www.sunbeltsoftware.com/Business/VIPRE-Enterprise/> ~ --- To manage subscriptions click here: http://lyris.sunbelt-software.com/read/my_forums/ or send an email to [email protected] with the body: unsubscribe ntsysadmin
<<personal2153c.jpg>>
<<g2supportsmall_250x58border7e87.png>>
