[Solved] Add text from 2 columns

[rbc]

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

Code: Select all

B1="Beth Lida section " &A1

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)

[UnklDonald418]

Try adding a new Sheet.
In cell B1 add the formula

Code: Select all

="Beth Lida section " &

Then select the first sheet and the cell containing "Row A Plot 1"
Press Enter to save the formula in the new Sheet.
Verify that it displays the correct values then Copy Down should also work.
If it continues to display the offset value I would create a new spreadsheet document and start over.

Yes, Paste Special with only a check mark in front of Text should get the results you want.

[rbc]

Try adding a new Sheet.
In cell B1 add the formula

Code: Select all

="Beth Lida section " &

Then select the first sheet and the cell containing "Row A Plot 1"
Press Enter to save the formula in the new Sheet.
Verify that it displays the correct values then Copy Down should also work.
If it continues to display the offset value I would create a new spreadsheet document and start over.

Yes, Paste Special with only a check mark in front of Text should get the results you want.

I copied in the formula from your reply and pointed to the adjacent cell. Copied down the column and this time seemed to work okay.