Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Excel 2002 : Why =Trim () formula not working ?
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="Guest, post: 10858123"] Dear Sir, I copied a list of reference number in HTML format from the MS Outlook and paste it to Excel worksheet. After that I separated it into columns by using Data > Text t to Columns function. A B 1 BJH3675 2 BGB1056 3 BHH9444 4 BJH978 5 BFU7095 6 BFU3422 7 BFG9144 8 BFN3659 9 BFN3756 After separation the data in B is in text format. I find that all the reference number in column B has 4 leading spaces. I tried to remove these empty spacing by using =TRIM( ) or =TRIM(CLEAN( )), but it does not work . May I know why this could happen and how to overcome this problem > Thanks Low [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Misc
Excel 2002 : Why =Trim () formula not working ?
Top
