vbanewbie68
Board Regular
- Joined
- Oct 16, 2021
- Messages
- 171
- Office Version
- 365
- Platform
- Windows
- MacOS
Dim Cel As Range
'
For Each Cel In Range("Z1:Z" & Range("Z" & Rows.Count).End(xlUp).Row)
If Left(Cel.Value, 3) = "+44" Then Cel.Value = Right(Cel.Value, Len(Cel.Value) - 3)
Next
Thank you so much sir! I am pleased to tell you that it is working with adding zero at the front of the mobile phone. Thanks again for your kind help on this matter which is greatly appreciatedVBA Code:Cells(x, OptInSMSNumber).Value = "0" & Right(Cells(x, OptInSMSNumber).Value, Len(Cells(x, OptInSMSNumber).Value) - 3)