Removing codes from an excel

[bajrang2101]

Hi All,

I have downloaded a copy from a Test management tool and somehow few cells in it are having the VBA codes in it.
For example one of the cell displays the below value:
4. Clicking 'Select' will open the Product and Benefit page. 5. The system will NOT ALLOW changes on Product and Benefit info screen since the Premium has been calculated for the benefit range selected. 6. The system will

 <span style="background-color: rgb(255, 255, 153);">

NOT ALLOW changes on Premium Parameters screen since the Premium has been calculated for the benefit range selected.

I want to get rid of the text or code as wrapped between codes. The excel is a huge one and doing it manually is very tedious and time consuming task. Can anybody please help me to remove this with the help of some macro or in-built tool in excel?

It would be of immense help.

Thanks in advance

 

[bajrang2101]

Can anybody please help me with this?

 

[Michael M]

What code are you trying to get rid of ??
If this is a downloaded worksheet written by the Test Management company it's probably protected and can't be modified or removed !!

 

[bajrang2101]

What code are you trying to get rid of ??
If this is a downloaded worksheet written by the Test Management company it's probably protected and can't be modified or removed !!

No Michael, I don't think it is protected. We can modify the entire excel as per our wish. In some cells the junk has got appended with the normal text. for example:

The expected result of this should be

 [FONT=Arial][SIZE=1][FONT=Arial][SIZE=1] [LEFT]<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New [/SIZE][/FONT][/SIZE][/FONT][FONT=Arial][SIZE=1][FONT=Arial][SIZE=1]Roman'">[/LEFT][/SIZE][/FONT][/SIZE][/FONT]

as per actual.

This kind of VBA codes is pressent in most of the cells.

 

[Michael M]

CAn you post a sample of the data...it doesn't appear to be VBA code

 

[bajrang2101]

CAn you post a sample of the data...it doesn't appear to be VBA code

Hi Michael,

Here goes the sample data from one of the cell. Texts with junk( I would say) is visible which I want to remove.

<COLGROUP><COL width=419></COLGROUP><TBODY>
[TD="width: 419"] 1. <SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'">At least one Contract exists in the System 2.
****** content=Word.Document name=ProgId>
****** content="Microsoft Word 11" name=Generator>
****** content="Microsoft Word 11" name=Originator><LINK href="file:///C:%5CDOCUME%7E1%5CRVaksman%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C17%5Cclipfilelist.xml" rel=File-List>
<STYLE>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</STYLE>
<SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Times New Roman'">Contract Admin GMD Edit, Contract Admin Actuarial Edit, Superuser [/TD]

</TBODY>

 

[Michael M]

Looks like HTML !
I'm guessing the download from the site hasn't worked correctly or fully downloaded properly.
I'd try it again.
Otherwise, I'd hope someone else can shed further light on the problem !!