Posted to microsoft.public.excel.programming

Maileen[_2_] Maileen[_2_] is offline

external usenet poster

Posts: 9

erase all space characters into string

Hi,

I would like to know how can i do to erase all space characters into a
string ?

i tried TRIM but it's only for left and right sides, not for inside the
string itself..

I would like to get from " this is a string ", this string "thisisastring".

should i proceed characters per character ?

thx,
Maileen

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
Return cell characters after space	Andy	Excel Worksheet Functions	3	April 30th 23 12:22 PM
Inserting a space between characters in a cell	mrmnz	Excel Discussion (Misc queries)	5	April 2nd 23 01:55 PM
Insert Leading Characters If String Is Only 7 Characters	Paperback Writer	Excel Discussion (Misc queries)	2	April 21st 09 09:07 PM
Put A Space Between 2 right characters	carl	Excel Worksheet Functions	3	April 8th 08 05:08 PM
cHARACTERS BEFORE THE SPACE	T De Villiers	Excel Worksheet Functions	3	January 19th 06 01:22 AM

All times are GMT +1. The time now is 08:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us