Stats: 3,188,386 members, 7,934,363 topics. Date: Thursday, 29 August 2024 at 03:19 AM |
Nairaland Forum / Science/Technology / Computers / Please Help With This Excel!!!! (2454 Views)
Why You Should Learn Microsoft Excel, Access And Powerpoint / Introduction To Ms-excel (excel 2007, 2010, 2013 And 2016) / Post All Your Microsoft Excel Problems Here (2) (3) (4)
Please Help With This Excel!!!! by Abduletudaye(m): 9:35pm On Apr 26, 2016 |
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!! |
Re: Please Help With This Excel!!!! by tripplephi: 9:52pm On Apr 26, 2016 |
Abduletudaye: 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 |
Re: Please Help With This Excel!!!! by Abduletudaye(m): 10:07pm On Apr 26, 2016 |
tripplephi: Uncle, i cant locate it. i have looked for over 3min without seeing any numerical function. pls epp me.. 1 Like |
Re: Please Help With This Excel!!!! by tripplephi: 11:49pm On Apr 26, 2016 |
Abduletudaye: My brother this thing is also based on the version of Microsoft Office you use o. |
Re: Please Help With This Excel!!!! by Bonethugss: 12:47am On Apr 27, 2016 |
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 |
Re: Please Help With This Excel!!!! by ephemm(m): 2:08am On Apr 27, 2016 |
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.
|
Re: Please Help With This Excel!!!! by dellsystems: 6:34am On Apr 27, 2016 |
tripplephi:. 1 Like |
Re: Please Help With This Excel!!!! by Abduletudaye(m): 6:48am On Apr 27, 2016 |
tripplephi: is 2010 i am use...please epp.. 1 Like |
Re: Please Help With This Excel!!!! by ephemm(m): 11:52am On Apr 27, 2016 |
Abduletudaye: Have u been able to do it? 1 Like 1 Share |
Re: Please Help With This Excel!!!! by tripplephi: 3:10pm On Apr 27, 2016 |
youtube com/ watch?v= C-bIzfUUQDA i am a very busy dude but i have put the video u need here. enjoy. 1 Like 1 Share |
Re: Please Help With This Excel!!!! by Abduletudaye(m): 1:17am On May 01, 2016 |
ephemm: brother, i tried it but i still get zeros in the mix... i think am doing something wrong.. |
Re: Please Help With This Excel!!!! by Abduletudaye(m): 1:25am On May 01, 2016 |
tripplephi: thanks but the video didnt work for me.. |
Re: Please Help With This Excel!!!! by tripplephi: 1:35am On May 01, 2016 |
Abduletudaye: Oh but why 1 Like 1 Share |
Re: Please Help With This Excel!!!! by Abduletudaye(m): 9:16am On May 01, 2016 |
tripplephi: 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 |
Re: Please Help With This Excel!!!! by Nobody: 10:30pm On May 02, 2016 |
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. |
Re: Please Help With This Excel!!!! by Didijiji: 1:09pm On Jun 26, 2023 |
ephemm:Thanks.... this really helped |
Re: Please Help With This Excel!!!! by kpezi: 9:57pm On Jun 27, 2023 |
ephemm: Nice. Thanks |
(1) (Reply)
Urgent: How Do I Edit Pdf Document On My Pc / High Quality Thermal Paste For Processrs / Can One Use A Dstv Card On A Strong Decoder By Hitv
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 21 |