Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Apostrophes in formula bar
I have been given a worksheet with hunderds of rows and a couple dozen
columns. All the data entry has been preceeded by an apostrophe in the formula input bar. I tried find/replace, but it does not see the apostrophes. Could someone please tell me how to do a global erasure of these apostrophes throughout the entire worksheet? Thanks so much for you help Joanne |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Apostrophes in formula bar
Joanne,
Select all your cells, and run this macro Sub PutValues() Set myRange = Intersect(Selection, ActiveSheet.UsedRange) myRange.Value = myRange.Value End Sub HTH, Bernie MS Excel MVP "Joanne" wrote in message ... I have been given a worksheet with hunderds of rows and a couple dozen columns. All the data entry has been preceeded by an apostrophe in the formula input bar. I tried find/replace, but it does not see the apostrophes. Could someone please tell me how to do a global erasure of these apostrophes throughout the entire worksheet? Thanks so much for you help Joanne |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Apostrophes in formula bar
Thank you, Thank you for your very prompt and expert help
Much appreciated indeed Joanne Bernie Deitrick wrote: Sub PutValues() Set myRange = Intersect(Selection, ActiveSheet.UsedRange) myRange.Value = myRange.Value End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
apostrophes | Excel Discussion (Misc queries) | |||
Apostrophes in Cell | Excel Worksheet Functions | |||
Apostrophes and Sorting | Excel Discussion (Misc queries) | |||
Apostrophes instead of equals in Excel | Excel Worksheet Functions | |||
how do i get rid of hidden apostrophes in cells? | Excel Worksheet Functions |