Please look into the following
data on b1
+255612143990
+255621222177
+255621881044
+255622599107
+255623019600
+255624495460
+255625528345
+255627311080
+255627563446
+255627603636
need formula to do the following on c1 and downwards
+255 612 143 990
+255 621 222 177
+255 621 881 044
+255 622 599 107
+255 623 019 600
+255 624 495 460
+255 625 528 345
+255 627 311 080
+255 627 563 446
+255 627 603 636
Thank you
Try:
=LEFT(B1,4)&" "&MID(B1,5,3)&" "&MID(B1,8,3)&" "&MID(B1,11,3)
Or:
="+"&LEFT(B1,3)&" "&MID(B1,4,3)&" "&MID(B1,7,3)&" "&MID(B1,10,3)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Maybe this, copied down:Formula:
=TEXT(B1+0,"+### ### ### ###")
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
wow TMS , thank you ALIGW
You're welcome. Thanks for the rep.
You don't need a second column
Just change celformat to:
### ### ### ###
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks