| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Uploading reports into excel
my cells have a ' in them - any ideas on how to remove from cells?
example: '12-FEB-09 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Uploading reports into excel
Enter 1 in any empty cell
Copy the cell Select the cells with ' in it Right-click and choose Paste Special Click on Multiply and then click OK That shoud do it... "KristinaMac" wrote: my cells have a ' in them - any ideas on how to remove from cells? example: '12-FEB-09 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
| Uploading Excel to web site | Excel Discussion (Misc queries) | |||
| Uploading data to an Ingres Db from excel | Excel Discussion (Misc queries) | |||
| Uploading excel files: Useful and Cool | Excel Discussion (Misc queries) | |||
| Uploading Excel file on-line | Excel Discussion (Misc queries) | |||
Linear Mode
