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

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

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

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

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

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