combining text

[Jeanette]

Does anyone know how to combine 2 columns of text into 1? For instance if
you have an address that is in column A1 & A2 and you want all of it in
column A1?

 

[FSt1]

hi
you might consider a formula
=A1&B1
if you need spaces between the data...
=A1&" "&B1

copy the formula down as far as you need. copy the formula column and paste
special Values. you can then delete the original data.

regards
FSt1

 

[tompl]

Put the formula =A1 & B1 in cell C1 (or some other cell). You might want to
put a comma and a space between the two so the formula would become =A1 & ",
" & B1. You can copy the formula down the column as far as you need to. You
could then copy, and paste special - values into cell D1 so that you have
text rather than a formula.

Tom

 

[James]

Enter this in Cell C1 =CONCATENATE(A1," ",B1)

 

[מיכ×ל (מיקי) ×בידן]

If you really meant to concatenate A1&B1 into A1(!) - run the following macro:
-------------------------------------------------
Sub ConcatenateA1B1intoA1()
LR = Cells(Rows.Count, 1).End(xlUp).Row
For R = 1 To LR
Cells(R, 1) = Cells(R, 1) + " " + Cells(R, 1).Offset(0, 1)
Cells(R, 1).Offset(0, 1) = ""
Next
End Sub