LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default remove square at end of data

Try it with a few different "box" characters and report back your results.

serendipity258 wrote:

I think you should be able to do a pretty simple find and replace. Copy the
symbol, go to the "replace" (ctrl+h in windows), paste that symbol in the
"Find What" box, and leave the "Replace With" box empty. Hit "Replace All"
and it should replace all intances of that symbol with nothing.

Jeff W wrote:

I was opening a text file with the excel app. It is a list of serial
numbers. When I open it, there is a small square figure at the end of some
of the serial numbers. What is it and how do I remove it without going to
each of 20,000 lines?
--
Jeff W


--

Dave Peterson
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I a rotate my square radar chart (square-diamond)? Becs I Know Nathing Charts and Charting in Excel 5 April 3rd 23 07:30 PM
Convert a square of data into a PivotTable? The Mighty Ox Excel Discussion (Misc queries) 1 September 4th 06 09:46 PM
how to center a square plot area in a square chart xppuser Charts and Charting in Excel 2 March 11th 06 08:13 AM
Regression Output -- R Square versus Adjusted R Square Bonnie Excel Discussion (Misc queries) 1 October 25th 05 12:55 AM
plot 10 data pts in least square fit to find slope and intercept engineeringdoll Excel Worksheet Functions 1 April 14th 05 01:56 PM


All times are GMT +1. The time now is 11:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"