₦airaland Forum

guys, evening. i have alot of phone numbers but i wanna replace the beginning with 234.

i really dunno how to do it. i have tried 'find and replace' command but its not working..

please gurus help!!

Abduletudaye:
guys, evening. i have alot of phone numbers but i wanna replace the beginning with 234.

i really dunno how to do it. i have tried 'find and replace' command but its not working..

please gurus help!!

Use the numerical function under the insert tab and you will have to select the entire row n column containing the numbers then click on the function and set it to phone contact

tripplephi:
Use the numerical function under the insert tab and you will have to select the entire row n column containing the numbers then click on the function and set it to phone contact

Uncle, i cant locate it. i have looked for over 3min without seeing any numerical function. pls epp me..

Abduletudaye:
Uncle, i cant locate it. i have looked for over 3min without seeing any numerical function. pls epp me..

My brother this thing is also based on the version of Microsoft Office you use o.

You need to use the CONCATENATE function. In a new column write =CONCATENATE("234", "click on the second cell"). Press enter.
This should join the contents of the 2 cells together. note that first the cell with the number should be changed to general or text data type, in the ribbon.
Hope that helps

Take the following steps to resolve it:
Assuming the phone numbers you already have are in column A
1. In column B, write this formula =RIGHT(A1,10)
the essence of this is to take the last 10 digits to your right, with this, you have successfully removed the first digit "0".

2. In column C, write this formula ="+234"&B1
This mean add +234 to the 10 digits in column B as in 1 above.

3. Highlight column B and C and drag formula to the last row of column A.

I have attached pix to guide U.

If you need additional information, contact me thru my moniker

Good luck.

tripplephi:
My brother this thing is also based on the version of Microsoft Office you use o.

.

tripplephi:
My brother this thing is also based on the version of Microsoft Office you use o.

is 2010 i am use...please epp..

Abduletudaye:
is 2010 i am use...please epp..

Have u been able to do it?

youtube com/ watch?v= C-bIzfUUQDA

i am a very busy dude but
i have put the video u need here. enjoy.

ephemm:
Have u been able to do it?

brother, i tried it but i still get zeros in the mix... i think am doing something wrong..

tripplephi:
youtube com/ watch?v= C-bIzfUUQDA

i am a very busy dude but
i have put the video u need here. enjoy.

thanks but the video didnt work for me..

Abduletudaye:
thanks but the video didnt work for me..

Oh but why

tripplephi:
Oh but why

U did the exact thing the lady did and it did the exact thing to my work.

I want 23480 kinda stuff and not (0803)- blah blah...

Thanks tho

Why not just contract it out to someone who can do it for you for a fee? You dont seem to be getting the help given.

ephemm:
Take the following steps to resolve it:
Assuming the phone numbers you already have are in column A
1. In column B, write this formula =RIGHT(A1,10)
the essence of this is to take the last 10 digits to your right, with this, you have successfully removed the first digit "0".

2. In column C, write this formula ="+234"&B1
This mean add +234 to the 10 digits in column B as in 1 above.

3. Highlight column B and C and drag formula to the last row of column A.

I have attached pix to guide U.

If you need additional information, contact me thru my moniker

Good luck.

Thanks.... this really helped

ephemm:
Take the following steps to resolve it:
Assuming the phone numbers you already have are in column A
1. In column B, write this formula =RIGHT(A1,10)
the essence of this is to take the last 10 digits to your right, with this, you have successfully removed the first digit "0".

2. In column C, write this formula ="+234"&B1
This mean add +234 to the 10 digits in column B as in 1 above.

3. Highlight column B and C and drag formula to the last row of column A.

I have attached pix to guide U.

If you need additional information, contact me thru my moniker

Good luck.

Nice. Thanks