Guys, Am not the best in MS Office, I need some help, probably it will brighten someone's evening laughing at me. I have an excel sheet with mobile numbers in the format: 0722123456 I would like to change the entire row automatically (if possible) to: 254722123456 Someone please assist if you are able to. -- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
Use the CONCATENATE function in MS Excel . Use two columns ; one with the mobile phone numbers ,another with '254' and use the third column to get the final output. On Fri, Sep 10, 2010 at 6:26 PM, David Mugo <raidarmax@gmail.com> wrote:
Guys,
Am not the best in MS Office, I need some help, probably it will brighten someone's evening laughing at me. I have an excel sheet with mobile numbers in the format:
0722123456
I would like to change the entire row automatically (if possible) to:
254722123456
Someone please assist if you are able to.
-- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
Thanks Kevin, it worked. David. On Fri, Sep 10, 2010 at 8:37 PM, Kevin Oeba <oeba.kevin@gmail.com> wrote:
Use the CONCATENATE function in MS Excel . Use two columns ; one with the mobile phone numbers ,another with '254' and use the third column to get the final output.
On Fri, Sep 10, 2010 at 6:26 PM, David Mugo <raidarmax@gmail.com> wrote:
Guys,
Am not the best in MS Office, I need some help, probably it will brighten someone's evening laughing at me. I have an excel sheet with mobile numbers in the format:
0722123456
I would like to change the entire row automatically (if possible) to:
254722123456
Someone please assist if you are able to.
-- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
Good stuff... On Fri, Sep 10, 2010 at 6:57 PM, David Mugo <raidarmax@gmail.com> wrote:
Thanks Kevin, it worked.
David.
On Fri, Sep 10, 2010 at 8:37 PM, Kevin Oeba <oeba.kevin@gmail.com> wrote:
Use the CONCATENATE function in MS Excel . Use two columns ; one with the mobile phone numbers ,another with '254' and use the third column to get the final output.
On Fri, Sep 10, 2010 at 6:26 PM, David Mugo <raidarmax@gmail.com> wrote:
Guys,
Am not the best in MS Office, I need some help, probably it will brighten someone's evening laughing at me. I have an excel sheet with mobile numbers in the format:
0722123456
I would like to change the entire row automatically (if possible) to:
254722123456
Someone please assist if you are able to.
-- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
-- ------------- David Mugo, ICT & E-Commerce Consultant, http://majibu.com Twitter: @raidarmax
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke
participants (2)
-
David Mugo -
Kevin Oeba