Replace character in string, not document

Posted to microsoft.public.excel.programming

KS[_2_]

external usenet poster

Posts: 5

Replace character in string, not document

Hello all.

I have a macro in which I save the document creating the filename based
on selected text in the document. However in some cases, the selected
text looks like "995451/U." Obviously I cannot save using this name. I
would like to convert this to "995451-U" for saving purposes only but
NOT in the document. How can I do this?

Thanks,

KS

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel-Match 1st text character in a string to a known character?	bushlite	Excel Worksheet Functions	2	January 15th 07 06:36 PM
How do I replace last numeric string from a alphanumeric string?	Christy	Excel Discussion (Misc queries)	3	August 11th 06 12:17 AM
Function to return Character Position of Xth character within a string	Andibevan[_2_]	Excel Programming	4	June 9th 05 03:24 PM
How do I replace * as a character in a string in Excel?	nicolegt	Excel Programming	1	January 21st 05 10:42 AM
How to replace this character ...	Harish Mohanbabu	Excel Programming	2	February 18th 04 04:20 PM

All times are GMT +1. The time now is 09:41 PM.

Menu

About Us