Solved

Combining Two Excel Columns

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This article will show you how to use shortcut menus in the Access run-time environment.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

920 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

16 Experts available now in Live!

Get 1:1 Help Now