Try something like this:

=A1&A2&A3

or

=TRIM(A1)&" "&SUBSTITUTE(TRIM(B1),CHAR(10),"")

If you need to use VBA, let post back.


"nabanco" wrote:

Hello,

Is there a way to combine row A and B into one row? For example, I have
data in both rows. Both rows are for the same borrower. I am trying to
combine row A and B into one row that has all the data both A and B had.

I know I can cut and paste each line, but the spreadsheet is large. Any
ideas?

Thank you