|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 7th, 2010, 08:49 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.................. 
|
|
#2
May 7th, 2010, 08:55 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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..................
|
|
#3
May 7th, 2010, 09:01 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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..................
|
|
#4
May 7th, 2010, 09:12 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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..................
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
