Posted to microsoft.public.excel.worksheet.functions

Steve

external usenet poster

Posts: 1,814

How do I remove non-numerical charaters from a string?

I have data formatted like 038-1439-00 and I would like to remove the dashes
so that the cell reads 038143900. Is there a formula in Excel that can strip
out the dashes?

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
Identify if a cell contains a numerical string	Pierre	Excel Worksheet Functions	3	January 15th 08 06:58 PM
Counting Charaters	Coccoleggs	Excel Worksheet Functions	8	September 21st 07 05:06 PM
TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â 033Â 546"	NAEEM	Excel Worksheet Functions	8	December 5th 06 07:30 PM
remove text from string	Todd	Excel Worksheet Functions	3	May 25th 06 11:10 PM
remove leading zero from a string..	clegge	Excel Worksheet Functions	3	December 27th 05 09:04 PM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us