#1   Report Post  
Posted to microsoft.public.excel.misc
trafficbroker
 
Posts: n/a
Default Find and Replace


Hi everyone

Just a quick question I cant find the answer to anywhere! How do you do
a find and replace for functional symbols such as ? or *

Thanks in advance,

Matt
Traffic Broker


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile: http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=491460

  #2   Report Post  
Posted to microsoft.public.excel.misc
Otto Moehrbach
 
Posts: n/a
Default Find and Replace

Put a tilde "~" in front of the symbol. HTH Otto
"trafficbroker"
wrote in message
news:trafficbroker.1zocxc_1133967012.9132@excelfor um-nospam.com...

Hi everyone

Just a quick question I cant find the answer to anywhere! How do you do
a find and replace for functional symbols such as ? or *

Thanks in advance,

Matt
Traffic Broker


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile:
http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=491460



  #3   Report Post  
Posted to microsoft.public.excel.misc
trafficbroker
 
Posts: n/a
Default Find and Replace


ah great thanks very much. Making hundreds of macros for sorting some
data today so better get back to it!

Thanks for your help.

Matt


--
trafficbroker
------------------------------------------------------------------------
trafficbroker's Profile: http://www.excelforum.com/member.php...o&userid=28710
View this thread: http://www.excelforum.com/showthread...hreadid=491460

  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Find and Replace

"Hundreds of macros"?

Why?

What are you sorting that would require that many macros?


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 09:26:58 -0600, trafficbroker
wrote:


ah great thanks very much. Making hundreds of macros for sorting some
data today so better get back to it!

Thanks for your help.

Matt

Reply
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
Find and Replace koba Excel Discussion (Misc queries) 1 November 23rd 05 10:19 PM
find replace format neeraj Excel Discussion (Misc queries) 6 September 20th 05 05:50 PM
Find & Replace in VB macro JackC Excel Discussion (Misc queries) 1 August 24th 05 09:22 PM
Find and replace of word causes change of font formatting jwa90010 New Users to Excel 4 July 22nd 05 08:10 PM
VB Find and Replace Bony_Pony Excel Worksheet Functions 10 December 6th 04 05:45 PM


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