Solved

Problems with Concatenation Excel Formula

Posted on 2016-09-21
3
59 Views
Last Modified: 2016-09-21
Hi Guys, I have a problem with a Concatenation Formula in Column J in the attachment.
I received the spread sheet from France and instead of a Concatenation, it is showing "D2439&E2439" instead of the actual value. Any ideas?
20160901_LOB_extract-20160831-mensu.xlsx
0
Comment
Question by:JCutcliffe
[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
  • Learn & ask questions
3 Comments
 
LVL 31

Accepted Solution

by:
Subodh Tiwari (Neeraj) earned 250 total points
ID: 41808640
You need to change some settings...

Go to File --> Options --> Advanced --> Scroll down to the section "Display options for this worksheet" and uncheck the box for "Show formulas in cells instead of their calculated results"  --> OK

Now select the whole column J by clicking the column letter and change the format to General and now select the cell J2439 and press F2 (function key) and hit Enter. Now copy the formula down for rest of the cells.
That will resolve your issue.
0
 
LVL 26

Assisted Solution

by:ProfessorJimJam
ProfessorJimJam earned 250 total points
ID: 41808642
it is becuase the cell format is somehow messed up . click into that column and then under the DATA tab click on text to column then the "delimited option should be selected and then click finish and it will fix it.

2016-09-21-14_29_25-Microsoft-Excel-.png
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 41808680
The problem cells are defined as 'text' format, you can change that in the import by selecting the column and ticking 'General' as the format for column J. However the formula does not exist for all rows so it maybe something you added afterwards?
Select column J, right click, format cells, and choose general. You will then need to reenter the formula once (or just edit it (f2) and press return) and then copy it down to correct the rest.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

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