How to fix a combined sell resulted from a addition of two text cells

[Jatom2235]

I just create a third column adding two clumns, like name and surname in a third column.

When I want to copy paste that column in another ducument it comes an error because what I have in this third column is a formula.

I want to fix this third column and being able to copy paste it in another Excel

[#2]

@Jatom2235 

If you copy all three columns into your new spreadsheet, it should work normally. If you only want to copy the column with the formula into another spreadsheet, then you have to copy and then only paste values. This is an option on the Paste button.

I hope this has helped you. Otherwise, please explain again in more detail.

[#3]

@Jatom2235 Instead of simply pasting, click the lower half of the Paste button in the Clipboard group of the Home tab of the ribbon, and select Values.

[#4]

Copy the entire column and then paste with Values and Number formatting to get text or numbers.

[#5]

@sivakumarrj Thank you very much, I really appreciate your help