HI,
I need to merg colum E with f.. For complete home address.
As it stands now. Column E is the street number and Column F is the rest of
the street address.
Ex
3 is in Col E and Karista springs is in Col F
Help
Anthony Pharo

ant2hony wrote:
HI,
I need to merg colum E with f.. For complete home address.
As it stands now. Column E is the street number and Column F is the rest of
the street address.
Ex
3 is in Col E and Karista springs is in Col F
Help
Anthony Pharo


Make a new column with this formula
=(CONCATENATE(A1," ",B1)) copy down the column as needed.
I'm assuming you want a space between the 2 values.
Then copy and special paste values only. Delete unneeded
columns.

gls858

i'm no sure if this is what you want but say you want this in G1 then in
G1 input:

=CONCATENATE (E1, " ", F1)


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=532059