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

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..................
 
M

Max

The key you seek is to do Copy > paste special as values
(not just copy > paste)
voila? hit YES below
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
How to center adjust text above and image in a two column document. 1
Autonumber field in Excel that behaves the same as Access 0
Lookup against concatenated source value 4
How to make scroll bar permanently visible, Word 365 0
List all tables, including document structure 0
VLOOKUP source values are a formula result. Getting #N/A 7
Constructing Range Name calls with Concatenate 4

Top