Combining Two Excel Columns

Posted on 2014-01-21
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..
Question by:Eaddy Barnes
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 39

Accepted Solution

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

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


Assisted Solution

Sreeram earned 225 total points
ID: 39799125

use one of the below formula in column D1

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

2.  =A1& " " &B1


Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

615 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