LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default How to delete a ' from front of data

I have a spreadsheet that needs to be converted here at work. The problem is
that in a couple of columns such as 'South Dakota 'Illinois 'Nebraska
You do not see the (') until you are in the cell, is there a global way to
delete this?
There are way to many to try and fix manually. Any help would be appreciated.

Thanks,
Barb

 
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
can a symbol be inserted in front of existing data imsadrian Excel Discussion (Misc queries) 3 November 7th 07 03:44 PM
Automatic Removal of 0's in front of data James Excel Discussion (Misc queries) 1 May 28th 07 05:04 PM
How do I bring a certain data series to the front Adam P. Charts and Charting in Excel 1 January 3rd 06 08:36 PM
Front-End for an Excel Data Base Venkat Excel Discussion (Misc queries) 2 December 10th 05 05:50 AM
"Bring to Front" Data Labels? Rob Charts and Charting in Excel 2 April 3rd 05 04:59 PM


All times are GMT +1. The time now is 06:57 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"