Hi, I am not sure if I understood your problem correctly. If you want to clean all the leading and trailing spaces from data in column B and then use them in column C this nested function works perfectly:
=TRIM(SUBSTITUTE(B12,CHAR(160),CHAR(32))) Hope that helps. In case you need something else please elaborate your case. Warm regards, Anand Kumar. On Sep 25, 10:28 am, Jai <jaihumtu...@gmail.com> wrote: > Dear Groups Member, > > I want to Remove the Space, In Cloum C , Sheet Attach, Please Help me. > > Thanks for Advance. > > -- > Thanks For Mail. > > Remove the Space.xls > 1213KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts