merge columns e with f into e.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
i'm no sure if this is what you want but say you want this in G1 then in
G1 input:

=CONCATENATE (E1, " ", F1)
 
Back
Top