merge columns e with f into e.

[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

 

[gls858]

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

 

[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)