=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
<<g2supportsmall_250x58border7e87.png>>
<<personal2153c.jpg>>
