Use the CONCATENATE function in MS Excel . Use two columns ; one with the mobile phone numbers ,another with &#39;254&#39; and use the <br>third column to get the final output.<br><br><br><div class="gmail_quote">On Fri, Sep 10, 2010 at 6:26 PM, David Mugo <span dir="ltr">&lt;<a href="mailto:raidarmax@gmail.com">raidarmax@gmail.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Guys,<br><br>Am not the best in MS Office, I need some help, probably it will brighten someone&#39;s evening laughing at me. I have an excel sheet with mobile numbers in the format:<br>
<br>0722123456 <br><br>I would like to change the entire row automatically (if possible) to:<br>
<br>254722123456<br><br>Someone please assist if you are able to.<br clear="all"><font color="#888888"><br>-- <br>-------------<br>David Mugo,<br>ICT &amp; E-Commerce Consultant,<br><a href="http://majibu.com" target="_blank">http://majibu.com</a><br>

Twitter: @raidarmax<br><br>
</font><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
Skunkworks Server donations spreadsheet<br>
<a href="http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en" target="_blank">http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1fbjAwOUE&amp;hl=en</a><br>

------------<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>