Trying to combine my "street address " column and " street name " into one column ie 246 + freil rd = 246 freil rd
Assuming street address is in A1 and street name is in B1, in C1 use:
CONCATENATE(A1, " ", B1)That worked, thank you!
Trying to combine my "street address " column and " street name " into one column ie 246 + freil rd = 246 freil rd
Assuming street address is in A1 and street name is in B1, in C1 use:
CONCATENATE(A1, " ", B1)That worked, thank you!