Basic Excel Help....!

[Simon L]

Hi,

I am a newbie to this board and to excel.. I have a list of numbers:
07973190447
07788520694
07803297928
07753115869
07736777401

What I want to do is delete the 0 at the start and replace it with 44
is there a quick way of doing this...

Thanks,
Simo

 

[BrianB]

Copy this formula down the next column and format as number.

=A1+440000000000

 

[Simon L]

That's great thanks for your help.... :

 

[JMay]

Your number data looks like text already, to keep it text try:
=SUBSTITUTE(A5,"LEn(A5)-(len(A5)-1",44)
HTH

Hi,

I am a newbie to this board and to excel.. I have a list of numbers:
07973190447
07788520694
07803297928
07753115869
07736777401

What I want to do is delete the 0 at the start and replace it with 44,
is there a quick way of doing this...

Thanks,
Simon


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements