[Solved] Add text from 2 columns

Discuss the spreadsheet application

[Solved] Add text from 2 columns

Postby rbc » 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
Code: Select all   Expand viewCollapse view
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)
Last edited by rbc on Mon Feb 18, 2019 8:28 pm, edited 1 time in total.
-------------
Mac OSX 10.7 Lion
Apache OpenOffice 4.1.1 (Sep 2014)
rbc
 
Posts: 36
Joined: Mon Jul 28, 2014 5:26 am

Re: add text from 2 columns

Postby UnklDonald418 » Mon Feb 18, 2019 8:21 pm

Try adding a new Sheet.
In cell B1 add the formula
Code: Select all   Expand viewCollapse view
="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.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.6 & LibreOffice 6.1.1.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1059
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: add text from 2 columns

Postby rbc » Mon Feb 18, 2019 8:27 pm

UnklDonald418 wrote:Try adding a new Sheet.
In cell B1 add the formula
Code: Select all   Expand viewCollapse view
="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.
-------------
Mac OSX 10.7 Lion
Apache OpenOffice 4.1.1 (Sep 2014)
rbc
 
Posts: 36
Joined: Mon Jul 28, 2014 5:26 am


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 24 guests