merge columns e with f into e.

A

ant2hony

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
 
G

gls858

ant2hony said:
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
Click to expand...


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
 
R

rocket0612

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

=CONCATENATE (E1, " ", F1)
 
Top