[Solved] Add text from 2 columns
Posted: Mon Feb 18, 2019 6:19 pm
I have column A with row/plot numbers of graves (text) copied from a spreadsheet. To complete the information, I need to add the section name. I created column B with formula so that column B would read "Beth Lida section Row A Plot 1". However, the results are showing "Beth Lida section Row A Plot 2". One number being added to the Plot. As I fill the formula down the column, this happens for whatever value the Plot is.
Once I get this working, I believe I can cut and Paste Special to remove the formula from column B then delete column A. (This is going into a template so I cannot create extra columns)
Code: Select all
B1="Beth Lida section " &A1
Once I get this working, I believe I can cut and Paste Special to remove the formula from column B then delete column A. (This is going into a template so I cannot create extra columns)