Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'text
in each cell a ' precedes the contents ie. '01/01/1999 or 'Tuesday.
I can't find and replace the item (') as excel can not see it at the start of the cell I don't really want to multiply everything by 1 can you help me get rid of all the ' out of every cell many thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'text
Select all the cells you want to remove the asterisks from, then right click
the worksheet's tab and select View Code from the popup menu that appears. The will take you into the Visual Basic editor where you should see a window labeled Immediate (if you do not see it, press Ctrl+G)... copy/paste this line of code into the Immediate window... Selection.Value = Selection.Value and, with the caret (text cursor) on that line, hit the Enter key. When you go back to the worksheet, the asterisks in those selected cells should now be gone. -- Rick (MVP - Excel) "Ward" wrote in message ... in each cell a ' precedes the contents ie. '01/01/1999 or 'Tuesday. I can't find and replace the item (') as excel can not see it at the start of the cell I don't really want to multiply everything by 1 can you help me get rid of all the ' out of every cell many thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'text
This is from a reply by Gary''s Student to a similar question:
Select the cells in question and run: Sub quote_killer() For Each r In Selection If r.PrefixCharacter = "'" Then r.Value = r.Value End If Next End Sub If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/200...e-elses-macro/ Hope this helps, Hutch "Ward" wrote: in each cell a ' precedes the contents ie. '01/01/1999 or 'Tuesday. I can't find and replace the item (') as excel can not see it at the start of the cell I don't really want to multiply everything by 1 can you help me get rid of all the ' out of every cell many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text does not display in "Text boxs" and when wrapping text in a c | Excel Discussion (Misc queries) | |||
Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
Text not continuing to wrap for large block of text in Excel cell | Charts and Charting in Excel | |||
merged cells into one text cell, size varies dependant on text dat | Excel Discussion (Misc queries) | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions |