Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Changing data within one row
do you know a way of changing an entire row of telephone numbers so that they
have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
#2
|
|||
|
|||
Assume your first phone number is in A1, and the prefix you want to add is
555...add this to B1 and drag down: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: do you know a way of changing an entire row of telephone numbers so that they have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
#3
|
|||
|
|||
try
for each c in selection c.value="111 "& c next -- Don Guillett SalesAid Software "timmyg" wrote in message ... do you know a way of changing an entire row of telephone numbers so that they have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
#4
|
|||
|
|||
Hi and thanks for your help. I get that the calculation works which is great
but i can only get it to work for the cell A1. If i put the formula in to B1 it places the information into B1. What i really need to to replace all the info in the entire row A. Sorry if i have mis understood you but could you help any further? thank you so much!! "David Billigmeier" wrote: Assume your first phone number is in A1, and the prefix you want to add is 555...add this to B1 and drag down: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: do you know a way of changing an entire row of telephone numbers so that they have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
#5
|
|||
|
|||
If all the information is in row A, place this formula in A2 and drag it to
the right: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: Hi and thanks for your help. I get that the calculation works which is great but i can only get it to work for the cell A1. If i put the formula in to B1 it places the information into B1. What i really need to to replace all the info in the entire row A. Sorry if i have mis understood you but could you help any further? thank you so much!! "David Billigmeier" wrote: Assume your first phone number is in A1, and the prefix you want to add is 555...add this to B1 and drag down: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: do you know a way of changing an entire row of telephone numbers so that they have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
#6
|
|||
|
|||
thank you so much, great help. Now for the tricky part. I need to delete the
first number from each of the numbers in each of the cells for the row(in this case 0) and relace with the area code 01144. can this be done. thanks again "David Billigmeier" wrote: If all the information is in row A, place this formula in A2 and drag it to the right: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: Hi and thanks for your help. I get that the calculation works which is great but i can only get it to work for the cell A1. If i put the formula in to B1 it places the information into B1. What i really need to to replace all the info in the entire row A. Sorry if i have mis understood you but could you help any further? thank you so much!! "David Billigmeier" wrote: Assume your first phone number is in A1, and the prefix you want to add is 555...add this to B1 and drag down: =CONCATENATE("555-",A1) -- Regards, Dave "timmyg" wrote: do you know a way of changing an entire row of telephone numbers so that they have a national dial code before them, without having to manually go in and add it to each entry.i want to add the same infrmation to every cell for an entire row without deleting the current info within the cells. any ideas??? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
Changing the Direction of Data within a Column | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |