Add +44 IF first Number in the string is 7

[LondonSmudge]

Hi Guys,

Sorry I can't offer a formula, to demonstrate that i have at least tried... I know some people get annoyed if us noobs just walk in and ask for formulae, but I am not an excel user ordinarily and wouldn't know where to start...so apologies.

I'm looking for something that might be able to save me a few hours. Essentially as it says in the title, a formula that I can apply that will add "+44" IF and only If the first number in the string is a 7.

I managed to remove all of the 0's from the front of the numbers which helps, because I can now more easily identify the UK numbers which tend to start with a 7. I'll have some stragglers but this will fix a few thousand at least.

I hope you can help.

Yours Hopefully
LondonSmudge

[popipipo]

=if(left(a1;1)=7;44&....
Something like this???

[daffodil11]

Let's go to the land of imagination.

In Imagination Land you have a spreadsheet where A1 = "7ilovefatunicorns" and B1 = 56.

Well, in C1 I put: =IF(left(a1)=7,B1+44,B1)

The result in C1 is 100.

Now when I copy the formula down into C2, it adjusts its references and points to A2 and B2 instead.

A2 = "99luftballoons" and B2 = 5. The character is not a 7. C2 = 5.

[ben_hensel]

A1 = number string you're looking at

Please Login or Register  to view this content.

IF the first character from the left in cell A1 is a "7", then a "+44" will get slapped on the front.

That can pull down.

[LondonSmudge]

A1 = number string you're looking at

Please Login or Register  to view this content.

IF the first character from the left in cell A1 is a "7", then a "+44" will get slapped on the front.

That can pull down.

That can pull down.

You Sir, Are a gentleman and a scholar. Appropriate reputation etc added.

Thanks Dude
S