Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to get rid of " " when copy values?
How can I get rid of " " around the value when I copy the value from one cell
to an other. I make the copy by selecting Past special and then Values. It dosen´t write out " " in the cell but when looking at the value in a function it writes " " around the value. Ex; in the cell I can see 110000 but in the function I can see "110000". It´s getting wrong when I´m using a function how compares two cells where the first one say´s 110000 and the second one say´s "110000". |
#2
|
|||
|
|||
how to get rid of " " when copy values?
Select the range of cells that you want to clean. Then pull-down:
Edit Find and enter the double quote character. In the replace field enter nothing. The run find/replace . All the double quotes should vanish. -- Gary''s Student "Eldna" wrote: How can I get rid of " " around the value when I copy the value from one cell to an other. I make the copy by selecting Past special and then Values. It dosen´t write out " " in the cell but when looking at the value in a function it writes " " around the value. Ex; in the cell I can see 110000 but in the function I can see "110000". It´s getting wrong when I´m using a function how compares two cells where the first one say´s 110000 and the second one say´s "110000". |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i copy values that are in a column into a row elsewhere? | Excel Discussion (Misc queries) | |||
Copy VLookup Values | Excel Worksheet Functions | |||
Copy Function | Excel Discussion (Misc queries) | |||
How to copy values in various rows automatically | Excel Discussion (Misc queries) | |||
How do I copy only sub-totalled values - without any detail? | Excel Worksheet Functions |