I need help! How to concatenate and render the result?

[martin242]

Hi. Im stuck with this:

I have a database in excel very wrongly constructed. The data whic
should be in 1 cell is split in several cells.

I tried to merge this cells but the data in the left extreme cell i
the only thing that survives the operation.

I tried using a formula, for example:
=concatenate(a1;b1;c1)

That works, and puts together everything in a new cell, but when I wan
to copy the result and paste it to another document (the correc
database file) it pastes the formula and not the result itself.

Is there a way to render the result of a formula so when I click o
that cell I see just the result and no longer the formula?

Do you know another way to do what I want?

Thank you very much in advance,

Martin.

PD: I can post an example file is needed

 

[Andy B]

Hi

When you paste this into the other sheet use Edit / Paste Special / Values,
which will paste the result of the formula rather than the formula itself.

 

[Dean]

Do a paste special and paste values only. this should
paste only the data and not the formulas