| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Remove ' from the beging of the string
I have spreadsheet created by importing data from Primavera. In each cell
there is characted which looks like ' but it is not '. Search is not finding it. It is not shown in the cell, just in the formula bar. How I can remove it from all cells ??? Regards, Tony |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove ' from the beging of the string
What I need to do is to remove this formatting character which comes with
importing. If I will copy data, paste to Word as text only and bring it back cleaning is done. But how to do it directly in Excel ??? Regards, Tony "Tony" wrote: I have spreadsheet created by importing data from Primavera. In each cell there is characted which looks like ' but it is not '. Search is not finding it. It is not shown in the cell, just in the formula bar. How I can remove it from all cells ??? Regards, Tony |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove ' from the beging of the string
You could put a value of 1 in an unused cell, copy this value, select the
range you want to convert and then Past Special (Paste:All, Operation:Multiply, Skip blanks). This will remove all leading apostrophes. Cheers, Joerg Mochikun "Tony" wrote in message ... What I need to do is to remove this formatting character which comes with importing. If I will copy data, paste to Word as text only and bring it back cleaning is done. But how to do it directly in Excel ??? Regards, Tony "Tony" wrote: I have spreadsheet created by importing data from Primavera. In each cell there is characted which looks like ' but it is not '. Search is not finding it. It is not shown in the cell, just in the formula bar. How I can remove it from all cells ??? Regards, Tony |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Remove ' from the beging of the string
Perfect. Thank you.
Tony "Joerg" wrote: You could put a value of 1 in an unused cell, copy this value, select the range you want to convert and then Past Special (Paste:All, Operation:Multiply, Skip blanks). This will remove all leading apostrophes. Cheers, Joerg Mochikun "Tony" wrote in message ... What I need to do is to remove this formatting character which comes with importing. If I will copy data, paste to Word as text only and bring it back cleaning is done. But how to do it directly in Excel ??? Regards, Tony "Tony" wrote: I have spreadsheet created by importing data from Primavera. In each cell there is characted which looks like ' but it is not '. Search is not finding it. It is not shown in the cell, just in the formula bar. How I can remove it from all cells ??? Regards, Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Non-Numerics from String | Excel Programming | |||
| Remove specified value from string | Excel Programming | |||
| Remove specified string from value | Excel Programming | |||
| Remove specified value from string | Excel Programming | |||
| Remove part of string | Excel Programming | |||
Linear Mode
