Solved

Combining Two Excel Columns

Posted on 2014-01-21
2
291 Views
Last Modified: 2014-01-21
I have an excel file, now in column A1  I have some text and in column B1 i have currency. Now I want to have column A1 & B1 combined and both placed into column D1..

please see attached file..
Untitled.jpg
0
Comment
Question by:greeneel
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 275 total points
ID: 39799124
Try
=A1 & " " & B1

or most likely if your B value is properly a formatted number
=A1 & " " &text(B1,"$#,#0.00")

Thomas
0
 
LVL 3

Assisted Solution

by:Sreeram
Sreeram earned 225 total points
ID: 39799125
Hi

use one of the below formula in column D1

1.   =CONCATENATE(A1," ",B1)

2.  =A1& " " &B1

Thanks
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Outlook Free & Paid Tools
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question