How do you make the results of a concatenate permanent text?
 

I have two columns of text which I have concatenated but I need the results
to be text not just the results. I have tried copying the column to another
column - that doesn't work so..................

How do you make the results of a concatenate permanent text?
 

Did you try PasteSpecial Values?

"Susan" wrote in message
...
I have two columns of text which I have concatenated but I need the
results
to be text not just the results. I have tried copying the column to
another
column - that doesn't work so..................

How do you make the results of a concatenate permanent text?
 

copy/pastepaste specialvalues

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Susan" wrote in message
...
I have two columns of text which I have concatenated but I need the results
to be text not just the results. I have tried copying the column to
another
column - that doesn't work so..................

How do you make the results of a concatenate permanent text?
 

The key you seek is to do Copy paste special as values
(not just copy paste)
voila? hit YES below
--
Max
Singapore
---
"Susan" wrote:
I have two columns of text which I have concatenated but I need the results
to be text not just the results. I have tried copying the column to another
column - that doesn't work so..................