Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 114
  • Last Modified:

suffix 0 issue

I have a column with a load of mobile phone numbers. Some are incorrect, all should begin with a 0 but some dont. I need a formula in the next column (i.e B2) to essentially say if A2 doesnt begin with 0, add a 0 to the front and then the rest of the data after the 0, or if the data does bein with a 0, do nothing and just copy over the values as is.

so 7777888888 in A2 should be come 07777888888 in B2 after the formula. Whereas 07777888888 should stay the same in B2.
0
pma111
Asked:
pma111
  • 2
1 Solution
 
ProfessorJimJamCommented:
=IF(LEFT(A1,1)="0",A1,CONCATENATE("0",A1))
0
 
ProfessorJimJamCommented:
put the below formula in B2  and then drag down


=IF(LEFT(A2,1)="0",A2,CONCATENATE("0",A2))
0
 
pma111Author Commented:
many thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now