If it is formatted as text the formula won't work... I kept thinking there must be some hidden character in the space, if only I could determine what it was, so I pasted it into a MS Word document. Did you mean ? The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text. http://techese.net/trim-not/trim-not-working-excel-2007.html
Please try the request again. Register To Reply 08-10-2011,11:33 PM #4 tjj View Profile View Forum Posts Registered User Join Date 08-10-2011 Location USA MS-Off Ver Excel 2010 Posts 2 Re: Why does the trim() function The TRIM function removes spaces from text except for single spaces between words. Can I Use Trim to Remove All Whitespace? http://spreadsheets.about.com/od/excelfunctions/qt/080404_trim.htm
Thanks. :-) Top White Papers and Webcasts Popular Taking Business Intelligence to the Next Level MoreWhitePapers Best Answer 0 Mark this reply as the best answer?(Choose carefully, this can't be changed) I've tried different combinations of CLEAN and TRIM and nothing to this point works. A common problem is items with leading or trailing spaces.
Thanks so what do i do to remove the spaces in between –niko Sep 13 '11 at 10:29 Replace(Activesheet.cells(i,"C").value," ") would get rid of all spaces in the string. I don't understand this, but it worked. more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed Remove Non-breaking Spaces In Excel I've tried pasting into notepad and repasting it into excel before using TRIM.
Problem with revealing a hidden folder What should I do after sending a file to print with a typo? Trimall Excel I've tried paste with values only. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not Did you mean ?
Remove a Specific Character Next, you can use the SUBSTITUTE function to remove the forward slash from the text in cell B2. =SUBSTITUTE(B2,”/”,””) The first argument, B2, is the cell that What Is Char(160) One character is the forward slash, and the other character is a trailing space. Do you mean without vba just with formula's? –hydrox467 Mar 6 '12 at 5:38 I don't know if the ribbonified Excel 2010 can still export to comma or tab Function CleanSpace(ByVal strIn As String) As String strIn = Trim(strIn) ' // Replace all double space pairings with single spaces Do While InStr(strIn, " ") strIn = Replace(strIn, " ", "
Please download the attachment and check it out. http://www.mrexcel.com/forum/excel-questions/75875-when-trim-doesnt-work-what-do.html Not the answer you're looking for? Excel Trim Function Doesn't Work Should I report it? Excel Char 160 Do n and n^3 have the same set of digits?
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode http://techese.net/trim-not/trim-not-working-excel.html In this screenshot, the tiptech.html page is in both lists, but the VLOOKUP formula in cell C2 can’t find it. Excel Trim will remove all spaces except a single space between words. You're now being signed in. Excel Trim Formula Not Working
Please try again. About.com Autos Careers Dating & Relationships Education en Español Entertainment Food Health Home Money News & Issues Parenting Religion & Spirituality Sports Style Tech Travel 1 When Excel's TRIM Function Doesn't Final note: words in the column are often phrases (again with spaces leading the first word). Check This Out Storing passwords in access-restricted Google spreadsheets?
To remove these unwanted characters, you can use a combination of the TRIM, CLEAN, and SUBSTITUTE functions. Databases SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL SQLite MS Office Excel Access Word Web Development HTML CSS Color Picker Languages C Language More ASCII Table Linux UNIX Java share|improve this answer answered Oct 12 '13 at 19:13 RobDogNZ 111 add a comment| up vote 0 down vote Sometimes what looks to be a space is not a space but Excel Trim Not Removing Leading Spaces Michael S.
asked 4 years ago viewed 777053 times active 9 months ago Upcoming Events 2016 Community Moderator Election ends in 7 days Blog How We Make Money at Stack Overflow: 2016 Edition Add ons missing? It's name is QuickRows. this contact form Other times, it’s tougher to find the differences.
Does boiling tap water make it potable? Share Share this post on Digg Del.icio.us Technorati Twitter just_jon Book of the Month: I'm Not Really an MVP, I Just Play One on TV [j. All Rights Reserved.