Posted to microsoft.public.excel.programming

Mannyluk

external usenet poster

Posts: 6

Quick string thing!!!!

Hi,

In my excel sheet I have data such as :

MAC-103-234-234
MAC-103-234-234
MAC-103-234-234
MAC-103-234-234

I need to delete all the "-" and leave:

MAC103234234
MAC103234234
MAC103234234
MAC103234234

Any suggestions??

Cheers

Manny

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
One Last Thing	Coltsfan	Excel Discussion (Misc queries)	1	January 16th 06 08:42 PM
one more thing	Bompi	Excel Worksheet Functions	1	January 11th 05 08:09 PM
Doing it's own thing	André	Excel Programming	3	July 9th 04 11:30 PM
Another thing	Richard	Excel Programming	0	May 21st 04 04:21 PM
oh, and another thing	ted daniels	Excel Programming	2	April 22nd 04 05:34 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us