Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
Hello all,
I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
Dave B. wrote: Hello all, I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. Hi Dave B Not sure what "strike out" is but if you mean Strikethrough, then that should make no difference to your lookup, the value in the cell has not been altered. Regards Steve |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
Yes, strikethrough, that's what I meant. The entire sheet is formatted as
general, and I have done many of these lookups, and there isnt anything else special or different on this sheet excent that all the correction, that dont really need to be there anymroe, are red with a line through them. When I try and run a basic lookup, it errors out, and the error is something to the affect of odd or unrecognisable characters cause the lookup not to work. Any ideas? Also, the data in the strikethrough parts dont need to be in the sheet anymore anyway, so can they be globally removed form the sheet? Thanks Dave "Scoops" wrote: Dave B. wrote: Hello all, I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. Hi Dave B Not sure what "strike out" is but if you mean Strikethrough, then that should make no difference to your lookup, the value in the cell has not been altered. Regards Steve |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
CTRL + a(twice in 2003) to select all cells.
FormatCellsFont. Uncheck the "strikethrough" option to remove the formatting. I agree with Steve that the formatting will not cause errors in your lookups. To remove all the data that has been formatted with the "strikethrough" would require VBA or manual removal. Sub strike3() Dim ocell As Range For Each ocell In Selection If ocell.Font.Strikethrough = True Then ocell.Clear End If Next ocell End Sub Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 10:25:02 -0700, Dave B. wrote: Yes, strikethrough, that's what I meant. The entire sheet is formatted as general, and I have done many of these lookups, and there isnt anything else special or different on this sheet excent that all the correction, that dont really need to be there anymroe, are red with a line through them. When I try and run a basic lookup, it errors out, and the error is something to the affect of odd or unrecognisable characters cause the lookup not to work. Any ideas? Also, the data in the strikethrough parts dont need to be in the sheet anymore anyway, so can they be globally removed form the sheet? Thanks Dave "Scoops" wrote: Dave B. wrote: Hello all, I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. Hi Dave B Not sure what "strike out" is but if you mean Strikethrough, then that should make no difference to your lookup, the value in the cell has not been altered. Regards Steve |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
You could also do a Find All, looking for cells that are formatted with the
strikethrough font attribute, then select all from the Find box, activate Excel (de-activate the Find dialog), and delete. "Gord Dibben" wrote: CTRL + a(twice in 2003) to select all cells. FormatCellsFont. Uncheck the "strikethrough" option to remove the formatting. I agree with Steve that the formatting will not cause errors in your lookups. To remove all the data that has been formatted with the "strikethrough" would require VBA or manual removal. Sub strike3() Dim ocell As Range For Each ocell In Selection If ocell.Font.Strikethrough = True Then ocell.Clear End If Next ocell End Sub Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 10:25:02 -0700, Dave B. wrote: Yes, strikethrough, that's what I meant. The entire sheet is formatted as general, and I have done many of these lookups, and there isnt anything else special or different on this sheet excent that all the correction, that dont really need to be there anymroe, are red with a line through them. When I try and run a basic lookup, it errors out, and the error is something to the affect of odd or unrecognisable characters cause the lookup not to work. Any ideas? Also, the data in the strikethrough parts dont need to be in the sheet anymore anyway, so can they be globally removed form the sheet? Thanks Dave "Scoops" wrote: Dave B. wrote: Hello all, I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. Hi Dave B Not sure what "strike out" is but if you mean Strikethrough, then that should make no difference to your lookup, the value in the cell has not been altered. Regards Steve |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting Remooval
Duke
Good point to use Find and Replace.......if OP is running 2002 or newer. I forget the newer versions have the "format" feature. Gord On Thu, 20 Jul 2006 12:13:01 -0700, Duke Carey wrote: You could also do a Find All, looking for cells that are formatted with the strikethrough font attribute, then select all from the Find box, activate Excel (de-activate the Find dialog), and delete. "Gord Dibben" wrote: CTRL + a(twice in 2003) to select all cells. FormatCellsFont. Uncheck the "strikethrough" option to remove the formatting. I agree with Steve that the formatting will not cause errors in your lookups. To remove all the data that has been formatted with the "strikethrough" would require VBA or manual removal. Sub strike3() Dim ocell As Range For Each ocell In Selection If ocell.Font.Strikethrough = True Then ocell.Clear End If Next ocell End Sub Gord Dibben MS Excel MVP On Thu, 20 Jul 2006 10:25:02 -0700, Dave B. wrote: Yes, strikethrough, that's what I meant. The entire sheet is formatted as general, and I have done many of these lookups, and there isnt anything else special or different on this sheet excent that all the correction, that dont really need to be there anymroe, are red with a line through them. When I try and run a basic lookup, it errors out, and the error is something to the affect of odd or unrecognisable characters cause the lookup not to work. Any ideas? Also, the data in the strikethrough parts dont need to be in the sheet anymore anyway, so can they be globally removed form the sheet? Thanks Dave "Scoops" wrote: Dave B. wrote: Hello all, I am having an issue of special formats making lookups fail. On 2 excel sheets with data I need to merge, via lookup, both have multiple corrections on them. The problem lies in this, the corrections are done by using the "Strike out" feature, which causes errors in the lookup. Is there any way, or special syntax I cna use, possibly in the find and replace menu, to find ALL data with strike outs and remove them? Thanks Dave B. Hi Dave B Not sure what "strike out" is but if you mean Strikethrough, then that should make no difference to your lookup, the value in the cell has not been altered. Regards Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |