Advertisement

06.17.2005 at 07:22AM PDT, ID: 21461859
[x]
Attachment Details

How to remove all leading and trailing white space including tabs with a macro, trim does not work

Asked by m270350 in Microsoft Excel Spreadsheet Software

Tags: remove, space, white, trim



I have to submit this work today, would appreciate any help on this.


This is related to an earlier question I had posted, maybe Kevin or Patrick can help me out with this one.  I want to remove all spaces within a column.   The function that Kevin posted for me uses Trim as I was not as clear about the spaces within the column.  It seems the cells have tabs and leading and trailing white spaces.  How can I remove them with a macro.  Any feedback on this will be greatly appreciated.  To review the question I asked earlier please search for the following topic.  

Recurse through a column and get a value

Thanks,
m270350Start Free Trial
[+][-]06.17.2005 at 07:23AM PDT, ID: 14241121

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 07:45AM PDT, ID: 14241372

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 07:51AM PDT, ID: 14241433

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 07:51AM PDT, ID: 14241438

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:00AM PDT, ID: 14241559

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:09AM PDT, ID: 14241670

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:11AM PDT, ID: 14241702

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:27AM PDT, ID: 14241896

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:33AM PDT, ID: 14241967

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:34AM PDT, ID: 14241995

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.17.2005 at 08:48AM PDT, ID: 14242169

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zone: Microsoft Excel Spreadsheet Software
Tags: remove, space, white, trim
Sign Up Now!
Solution Provided By: zorvek
Participating Experts: 3
Solution Grade: A
 
 
[+][-]06.17.2005 at 09:27AM PDT, ID: 14242641

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32