Hi!
I have a list of strings in a column consists of Alphabets and Numeric
I would like to take off all the preceding spaces (all the spaces at the beginning of the string) excluding the spaces inside the string.
Appreciate your early reply!
Hi!
I have a list of strings in a column consists of Alphabets and Numeric
I would like to take off all the preceding spaces (all the spaces at the beginning of the string) excluding the spaces inside the string.
Appreciate your early reply!
Try using the TRIM() function in a helper column
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Use =Trim(A1)
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks