Solved

Combining Two Excel Columns

Posted on 2014-01-21
2
287 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now