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: 24
Default Replacing all asterisks in Excel 2003 spreadsheet

I am working on a spreadsheet that I have pulled data from another source.
Some of the cells contain double asterisks ** and other cells contain the
data that I want to work with.
I wanted to eliminate the ** so I tried to Replace All the ** with a space,
but when I do this all my data disappears.
Is there a way to eliminate the ** only and not the other data?
Thanks.

 
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
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 Stuart[_4_] Excel Discussion (Misc queries) 2 October 6th 08 05:07 PM
Replacing Values in a Spreadsheet In need of enlightenment[_2_] Excel Discussion (Misc queries) 0 March 28th 07 02:44 AM
Replacing Values in a Spreadsheet Joel Excel Discussion (Misc queries) 0 March 27th 07 11:44 PM
XL 2003: Replacing X-Axis Labels with Custom Ones... Birmangirl Charts and Charting in Excel 1 December 7th 05 04:09 AM
Asterisks in Excel Walsh jj Excel Discussion (Misc queries) 1 June 17th 05 10:28 PM


All times are GMT +1. The time now is 12:25 AM.

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"