Basic Excel Help....!

S

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
 
J

JMay

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

Simon L said:
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
Click to expand...
creating financial statements
 
Top