merge columns e with f into e.
 

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

merge columns e with f into e.
 

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

merge columns e with f into e.
 

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