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

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

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..................
 
The key you seek is to do Copy > paste special as values
(not just copy > paste)
voila? hit YES below
 
Back
Top