| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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.................. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make filter permanent | Excel Discussion (Misc queries) | |||
| how make formulate results in text? | Excel Discussion (Misc queries) | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| How do I make gridlines permanent? | Excel Discussion (Misc queries) | |||
| Concatenate text to make calculation | Excel Discussion (Misc queries) | |||
Linear Mode
