RE: Changing data within one row

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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
> > > >
.

Relevant Pages