add numbers in excel
How do I add a number such as +27 before a tel number, in a very large column
in excel. All the numbers should start with + 27. |
add numbers in excel
="+27 "&A1
HTH Carim |
add numbers in excel
If your list is in column A starting in cell A1, pick an empty column and
write the formula ="+27 "&A1 in a cell in the empty column which is in the same row as the first value in the original column. Then copy the formula down to the length of the original list. then select the new list and copy it, go to the top of your original list and paste, select the paste options icon (bottom right of the pasted list) and pick values and source formatting, now delete the list with the formula. "pleasehelpurgently" wrote: How do I add a number such as +27 before a tel number, in a very large column in excel. All the numbers should start with + 27. |
All times are GMT +1. The time now is 10:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com