Avatar of Star Gazr1
Star Gazr1
Flag for United States of America

asked on 

Excel Concatenation Formula

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
Microsoft Excel

Avatar of undefined
Last Comment

8/22/2022 - Mon