I have an excell worksheet that comes with the following information in each
column (not rows).
A First Name
B Last Name
C House Number
D Address
E City
F State
G Zip Code
H Area Code
I Phone Number
I need to merge the information in C with D (i.e. 123 Main Street in same
column). I also need to merge information from H with I (504 555 1212)
Help.
In column J (or wherever you have a free column) type this:
=CONCATENATE(C1," ",D1)
and drag down. Then copy this column and paste special->values into column
C or D. Use the same process for column H and I
--
Regards,
DavidB
"Jay T" wrote:
> I have an excell worksheet that comes with the following information in each
> column (not rows).
>
> A First Name
> B Last Name
> C House Number
> D Address
> E City
> F State
> G Zip Code
> H Area Code
> I Phone Number
>
> I need to merge the information in C with D (i.e. 123 Main Street in same
> column). I also need to merge information from H with I (504 555 1212)
>
> Help.
Or:
=C1&" "&D1
"DaveB" wrote:
> In column J (or wherever you have a free column) type this:
>
> =CONCATENATE(C1," ",D1)
>
> and drag down. Then copy this column and paste special->values into column
> C or D. Use the same process for column H and I
> --
> Regards,
>
> DavidB
>
>
> "Jay T" wrote:
>
> > I have an excell worksheet that comes with the following information in each
> > column (not rows).
> >
> > A First Name
> > B Last Name
> > C House Number
> > D Address
> > E City
> > F State
> > G Zip Code
> > H Area Code
> > I Phone Number
> >
> > I need to merge the information in C with D (i.e. 123 Main Street in same
> > column). I also need to merge information from H with I (504 555 1212)
> >
> > Help.
DaveB,
Thanks but I still don't have the information from the rows appearing in
column J.
"DaveB" wrote:
> In column J (or wherever you have a free column) type this:
>
> =CONCATENATE(C1," ",D1)
>
> and drag down. Then copy this column and paste special->values into column
> C or D. Use the same process for column H and I
> --
> Regards,
>
> DavidB
>
>
> "Jay T" wrote:
>
> > I have an excell worksheet that comes with the following information in each
> > column (not rows).
> >
> > A First Name
> > B Last Name
> > C House Number
> > D Address
> > E City
> > F State
> > G Zip Code
> > H Area Code
> > I Phone Number
> >
> > I need to merge the information in C with D (i.e. 123 Main Street in same
> > column). I also need to merge information from H with I (504 555 1212)
> >
> > Help.
That will work as well, essentially that is what the CONCATENATE() function
does behind the scenes.
--
Regards,
DavidB
"Duke Carey" wrote:
> Or:
>
> =C1&" "&D1
>
> "DaveB" wrote:
>
> > In column J (or wherever you have a free column) type this:
> >
> > =CONCATENATE(C1," ",D1)
> >
> > and drag down. Then copy this column and paste special->values into column
> > C or D. Use the same process for column H and I
> > --
> > Regards,
> >
> > DavidB
> >
> >
> > "Jay T" wrote:
> >
> > > I have an excell worksheet that comes with the following information in each
> > > column (not rows).
> > >
> > > A First Name
> > > B Last Name
> > > C House Number
> > > D Address
> > > E City
> > > F State
> > > G Zip Code
> > > H Area Code
> > > I Phone Number
> > >
> > > I need to merge the information in C with D (i.e. 123 Main Street in same
> > > column). I also need to merge information from H with I (504 555 1212)
> > >
> > > Help.
Well in my formula it is assuming that there is information in C1 and D1. If
not, change the formula to refer to the top of the column where your house
number and address information start and drag that down to the bottom.
Does that help?
--
Regards,
DavidB
"Jay T" wrote:
> DaveB,
>
> Thanks but I still don't have the information from the rows appearing in
> column J.
>
> "DaveB" wrote:
>
> > In column J (or wherever you have a free column) type this:
> >
> > =CONCATENATE(C1," ",D1)
> >
> > and drag down. Then copy this column and paste special->values into column
> > C or D. Use the same process for column H and I
> > --
> > Regards,
> >
> > DavidB
> >
> >
> > "Jay T" wrote:
> >
> > > I have an excell worksheet that comes with the following information in each
> > > column (not rows).
> > >
> > > A First Name
> > > B Last Name
> > > C House Number
> > > D Address
> > > E City
> > > F State
> > > G Zip Code
> > > H Area Code
> > > I Phone Number
> > >
> > > I need to merge the information in C with D (i.e. 123 Main Street in same
> > > column). I also need to merge information from H with I (504 555 1212)
> > >
> > > Help.
It worked for the information in row 1. But I have a list of 600 names,
address etc.
I am clicking on the top of the column and the whole column is highlighted.
Would I need to insert the function =CONCATENATE(C2," ",D2) for row two and
so on for 600 rows OR is there a way I can do the whole column?
"DaveB" wrote:
> Well in my formula it is assuming that there is information in C1 and D1. If
> not, change the formula to refer to the top of the column where your house
> number and address information start and drag that down to the bottom.
>
> Does that help?
> --
> Regards,
>
> DavidB
>
>
> "Jay T" wrote:
>
> > DaveB,
> >
> > Thanks but I still don't have the information from the rows appearing in
> > column J.
> >
> > "DaveB" wrote:
> >
> > > In column J (or wherever you have a free column) type this:
> > >
> > > =CONCATENATE(C1," ",D1)
> > >
> > > and drag down. Then copy this column and paste special->values into column
> > > C or D. Use the same process for column H and I
> > > --
> > > Regards,
> > >
> > > DavidB
> > >
> > >
> > > "Jay T" wrote:
> > >
> > > > I have an excell worksheet that comes with the following information in each
> > > > column (not rows).
> > > >
> > > > A First Name
> > > > B Last Name
> > > > C House Number
> > > > D Address
> > > > E City
> > > > F State
> > > > G Zip Code
> > > > H Area Code
> > > > I Phone Number
> > > >
> > > > I need to merge the information in C with D (i.e. 123 Main Street in same
> > > > column). I also need to merge information from H with I (504 555 1212)
> > > >
> > > > Help.
Yes in that case you would. Excel has some shortcuts to doing this, however.
Click on the cell where you have the =CONCATENATE(C1," ",D1) function. When
you do this the cell will be highlighted with a bold line around it. In the
bottom right corner of this cell you see a little black square, double click
on this and Excel will fill the ccolumn down to wherever the column right
next to it stops.
For example if you have information in column I, paste that concatenate
function into column J, when you double click the fill option it will fill
column J down to wherever column I stops. Excel will update the formula
respectively for each row changing the C1 and D1 to C2, D2.. C3, D3... ect.
--
Regards,
DavidB
"Jay T" wrote:
> It worked for the information in row 1. But I have a list of 600 names,
> address etc.
>
> I am clicking on the top of the column and the whole column is highlighted.
> Would I need to insert the function =CONCATENATE(C2," ",D2) for row two and
> so on for 600 rows OR is there a way I can do the whole column?
>
> "DaveB" wrote:
>
> > Well in my formula it is assuming that there is information in C1 and D1. If
> > not, change the formula to refer to the top of the column where your house
> > number and address information start and drag that down to the bottom.
> >
> > Does that help?
> > --
> > Regards,
> >
> > DavidB
> >
> >
> > "Jay T" wrote:
> >
> > > DaveB,
> > >
> > > Thanks but I still don't have the information from the rows appearing in
> > > column J.
> > >
> > > "DaveB" wrote:
> > >
> > > > In column J (or wherever you have a free column) type this:
> > > >
> > > > =CONCATENATE(C1," ",D1)
> > > >
> > > > and drag down. Then copy this column and paste special->values into column
> > > > C or D. Use the same process for column H and I
> > > > --
> > > > Regards,
> > > >
> > > > DavidB
> > > >
> > > >
> > > > "Jay T" wrote:
> > > >
> > > > > I have an excell worksheet that comes with the following information in each
> > > > > column (not rows).
> > > > >
> > > > > A First Name
> > > > > B Last Name
> > > > > C House Number
> > > > > D Address
> > > > > E City
> > > > > F State
> > > > > G Zip Code
> > > > > H Area Code
> > > > > I Phone Number
> > > > >
> > > > > I need to merge the information in C with D (i.e. 123 Main Street in same
> > > > > column). I also need to merge information from H with I (504 555 1212)
> > > > >
> > > > > Help.
Thank you DaveB.
YOU DA MAN!!!!!
"DaveB" wrote:
> Yes in that case you would. Excel has some shortcuts to doing this, however.
> Click on the cell where you have the =CONCATENATE(C1," ",D1) function. When
> you do this the cell will be highlighted with a bold line around it. In the
> bottom right corner of this cell you see a little black square, double click
> on this and Excel will fill the ccolumn down to wherever the column right
> next to it stops.
>
> For example if you have information in column I, paste that concatenate
> function into column J, when you double click the fill option it will fill
> column J down to wherever column I stops. Excel will update the formula
> respectively for each row changing the C1 and D1 to C2, D2.. C3, D3... ect.
> --
> Regards,
>
> DavidB
>
>
> "Jay T" wrote:
>
> > It worked for the information in row 1. But I have a list of 600 names,
> > address etc.
> >
> > I am clicking on the top of the column and the whole column is highlighted.
> > Would I need to insert the function =CONCATENATE(C2," ",D2) for row two and
> > so on for 600 rows OR is there a way I can do the whole column?
> >
> > "DaveB" wrote:
> >
> > > Well in my formula it is assuming that there is information in C1 and D1. If
> > > not, change the formula to refer to the top of the column where your house
> > > number and address information start and drag that down to the bottom.
> > >
> > > Does that help?
> > > --
> > > Regards,
> > >
> > > DavidB
> > >
> > >
> > > "Jay T" wrote:
> > >
> > > > DaveB,
> > > >
> > > > Thanks but I still don't have the information from the rows appearing in
> > > > column J.
> > > >
> > > > "DaveB" wrote:
> > > >
> > > > > In column J (or wherever you have a free column) type this:
> > > > >
> > > > > =CONCATENATE(C1," ",D1)
> > > > >
> > > > > and drag down. Then copy this column and paste special->values into column
> > > > > C or D. Use the same process for column H and I
> > > > > --
> > > > > Regards,
> > > > >
> > > > > DavidB
> > > > >
> > > > >
> > > > > "Jay T" wrote:
> > > > >
> > > > > > I have an excell worksheet that comes with the following information in each
> > > > > > column (not rows).
> > > > > >
> > > > > > A First Name
> > > > > > B Last Name
> > > > > > C House Number
> > > > > > D Address
> > > > > > E City
> > > > > > F State
> > > > > > G Zip Code
> > > > > > H Area Code
> > > > > > I Phone Number
> > > > > >
> > > > > > I need to merge the information in C with D (i.e. 123 Main Street in same
> > > > > > column). I also need to merge information from H with I (504 555 1212)
> > > > > >
> > > > > > Help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks