Excel 2007

Hi Kevin, thanks for your query. To do this you need to "concatenate" the data and include a single space for readability between the two joined pieces of text. If A1 and A2 contain the debit and credit data respectively, try this in A3

=A1 & " " & A2

That should glue the text together and you can Autofill down to populate the column. Note also there is a CONCATENATE function, which works in exactly the same way.

Hope this helps,

Anthony