removing unwanted characters from spreadsheet

B

boscosjs

I have saved a large web page with huge tables of numbers.
I open this file in IE and copy and paste the table into
an excel spreadsheet. The numbers are imported as text. I
find that each number is followed by a character 202 from
the Macintosh Character Set.

What I want is a simple way to remove these from within Excel.

If I import the data to word, I can do a replace (^0202)
with nothing and it replaces them. But this doesn't seem
to work within Excel. Since I have lots of them to do, I'd
like to avoid all the extra steps.

Thanks
 
J

John McGimpsey

boscosjs said:
I have saved a large web page with huge tables of numbers.
I open this file in IE and copy and paste the table into
an excel spreadsheet. The numbers are imported as text. I
find that each number is followed by a character 202 from
the Macintosh Character Set.

What I want is a simple way to remove these from within Excel.

If I import the data to word, I can do a replace (^0202)
with nothing and it replaces them. But this doesn't seem
to work within Excel. Since I have lots of them to do, I'd
like to avoid all the extra steps.

Thanks
Click to expand...

Do a replace, replacing opt-Space with nothing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unwanted color in cells of spreadsheet. How do I remove the color? 1
Merge field truncated to first 18 characters from source? 0
find and replace numeric strings in larger text strings 8
Styles Across Multiple Documents 1
Removing unwanted fonts 2
Remove characters 1
Make Table Query Truncating Memo Field at 255 Characters 1
replace characters in table 6

Top