Can anyone help me with a VBA macro to merge two non-blank cells into a third (blank) cell with a space between the text data? For example, part numbers (12345) in column A or B, Description (XYZ) in column C. The output should be in column D (12345 XYZ). Note: My data file is created from a data base that is not consitent in terms of data entry for column A and B. The result is sometimes the part number is in A and sometimes in B. I need to import the column D (output) data into another database, my peachtree accounting software. Option: I could add the text from A or B into C and not use D if that is easier.

Thanks in advance for any help.