troubleshooting Question

Excel Concatenation Formula

Avatar of fjkaykr11
fjkaykr11 asked on
Microsoft Excel
8 Comments1 Solution29 ViewsLast Modified:
in Excel 2019,  I am trying to apply a calculation to a concatenated column.  Attached is a sample spreadsheet. I am also attaching a screenshot as a reference to the info below. Column A and B has the values. Column C is concatenatenation of Column A and Column B Values
In Column D, I am trying to see if there is a method to reference the data in Column C and have it become a calculation.
Column E shows how to do this manually with a formula. I am working with a lot of information and the values change in column A and Column B, so that is why the way I set this up with the concatenation is going to be the easiest way to update, unless there is another method i haven't thought of.
Any info is appreciated.  Thanks very much.ScreenshotConcatenate_Formula.xlsx

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros