Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2007

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel 2007

Resolved · Low Priority · Version 2007

Reply Thu 15 Apr 2010, 16:33Delegate Kevin said...

Kevin has attended:
Excel Intermediate course
Excel Intermediate course
Excel Advanced course

Excel 2007

How do you combine 2 columns ,one which has debit data and one which has credit data into a single column

For upcoming training course dates see: Pricing & availability

Reply Fri 16 Apr 2010, 03:06Trainer Anthony said...

RE: 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

Reply Fri 16 Apr 2010, 03:06Trainer Anthony said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Thu 22 Apr 2010: Automatically marked as resolved.

Excel articles

· Microsoft Excel Features and Functions for Accountants
· How To Use The Page Layout Features In Excel 2007 And Excel 2010
· Compare Different MS Excel Training Methods
· How to Create Better Excel Spreadsheets: Part Four
· Share And Share Alike - Use Excel To Collaborate As A Winning Team!

Please browse our web site to find out more about
excel vba course london and other Microsoft training courses.

Excel tip:

Do a fast scroll

In big Excel databases with many records, you can move down thousands of rows super-fast as follows: hold down Shift then click on the scrollbar somewhere below the scrollbar handle. This will move you way down the sheet without your having to use the scrollbar up/down arrows or drag on the scrollbar handle.

View all Excel hints and tips