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.

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

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

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

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

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