Solved

Problems with Concatenation Excel Formula

Posted on 2016-09-21
3
56 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Automate an Oracle update in Excel 7 70
78 files, need to delete row 2 in every file 3 34
need help to look for 16 42
sort time order 10 46
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 article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

738 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