Posted to microsoft.public.excel.misc

Rusty

external usenet poster

Posts: 46

format string

I have a string imported from a ".csv file (phone number) as follows. "=1
123-456-7890).

I need to end up with a string formated as a # as followes (11234567890).
Can someone help this old man with a fancy hi-tech way of doen this. :-(

thanks
--
rustyrunrite

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
Converting a time format to a String format in Excel	Bill Partridge	Excel Discussion (Misc queries)	3	October 3rd 07 11:48 AM
Format text string	Saintsman	Excel Discussion (Misc queries)	2	April 2nd 07 11:56 AM
Reverse and format string	Mike	Excel Discussion (Misc queries)	3	October 31st 06 07:21 PM
Format amount in string	[email protected]	Excel Discussion (Misc queries)	2	October 13th 06 02:46 PM
Date format in string	Adam Thwaites	Excel Discussion (Misc queries)	3	May 10th 06 04:14 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us