TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â*033Â*546"

Posted to microsoft.public.excel.worksheet.functions

NAEEM

external usenet poster

Posts: 13

TRUNCATE SPACE FROM NUMERICAL STRING eg "33Â*033Â*546"

i want to remove space b/w these numbers.

3 087 159
33 033 546
63 330
69 031
13 115 606

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
Displays the number in text. (One thousand two hundred thirty four	Ashish Patel	Excel Worksheet Functions	1	March 20th 06 09:27 PM
Property Let: assign return value of Double when passing String	Tetsuya Oguma	Excel Discussion (Misc queries)	1	March 3rd 06 08:01 AM
Looking up a string of text within a string of text	tobriant	Excel Worksheet Functions	4	September 20th 05 06:59 PM
Auto convert an alphanumeric string (CIS9638S) to numbers only?	Gary L Brown	Excel Worksheet Functions	1	September 7th 05 01:17 AM
Read Text File into Excel Using VBA	Willie T	Excel Discussion (Misc queries)	13	January 8th 05 12:37 AM

All times are GMT +1. The time now is 05:57 AM.

About Us