LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,651
Default Stripping spaces using a formula, not VBA

On 26 Sep 2006 05:50:38 -0700, "Morris" wrote:



Look at HELP for the TRIM worksheet function.
--ron



"...or multiple embedded space characters ..."

thanks a lot I would never imagine that TRIM formula works in a
different way than a VBA function.

Thank you :)


VBA and Excel are really two different products. There are other functions
(e.g. Round) which also work differently in the two programs.
--ron
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Formula to add spaces in csv Wet Nose[_2_] Excel Discussion (Misc queries) 4 March 9th 10 03:45 PM
Formula for stripping text Vicky Excel Discussion (Misc queries) 6 June 19th 09 03:19 PM
formula to bring value from another sheet with different spaces veena Excel Discussion (Misc queries) 6 July 11th 08 12:25 AM
how do I remove leading spaces and leave the remianing spaces w Debi Excel Worksheet Functions 6 February 28th 07 03:29 PM
Stripping out imbedded spaces in a cell/row Tom Excel Worksheet Functions 8 April 22nd 05 03:49 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"