| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell format
Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
HI,
highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
Hi,
It says Excel can not find this ' to replace. I'm not sure why. Soth "Eduardo" wrote: HI, highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
Excel creates a text entry from the apostrophe. That's why you can't find
it. Use Text to Columns instead. Highlight the column. DataText to Columns NextNextFinish Regards, Fred. "Soth" wrote in message ... Hi, It says Excel can not find this ' to replace. I'm not sure why. Soth "Eduardo" wrote: HI, highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
Hi,
Do first text to columns, if it still doesn't find it, insert a column and enter this formula =trim(A1) change to your column, then copy this column as value over the original one "Soth" wrote: Hi, It says Excel can not find this ' to replace. I'm not sure why. Soth "Eduardo" wrote: HI, highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
Thank you much Fred. You're the best
"Fred Smith" wrote: Excel creates a text entry from the apostrophe. That's why you can't find it. Use Text to Columns instead. Highlight the column. DataText to Columns NextNextFinish Regards, Fred. "Soth" wrote in message ... Hi, It says Excel can not find this ' to replace. I'm not sure why. Soth "Eduardo" wrote: HI, highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell format
Got it ! Thank
"Eduardo" wrote: Hi, Do first text to columns, if it still doesn't find it, insert a column and enter this formula =trim(A1) change to your column, then copy this column as value over the original one "Soth" wrote: Hi, It says Excel can not find this ' to replace. I'm not sure why. Soth "Eduardo" wrote: HI, highlight the column, CTRL H, value to find enter ' replace with leave blank hope this helps "Soth" wrote: Hi- In a cell consist of this number '24110100, I did try copy and paste special trying to get rid of this apostrophe " ' " in front of number and I'm not able to do so. The other way is to delete it, but I have thousands of numbers. Is there a better way to get rid of this apostrophe ' sign? Thanks, Soth |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| cell format - remove cell format pattern without effecting colors | Excel Discussion (Misc queries) | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Linear Mode
