Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Combining Two Excel Columns

Posted on 2014-01-21
Medium Priority
368 Views
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..

Untitled.jpg
0
[X]
###### 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

LVL 39

Accepted Solution

nutsch earned 1100 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

Sreeram earned 900 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

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
###### Suggested Courses
Course of the Month7 days, 21 hours left to enroll