-
Recent Posts
- Excel VBA: Empty Clipboard Excel
- How to Get a Full File Path in Excel?
- Remove Non-AlphaNumeric Characters from String
- Sum Unique/Distinct Values in Excel
- Excel Extract Cell Comments
- How to get an Acronym using Excel VBA?
- Get Position of Last Column Containing Data with Excel VBA
- Find the Last Day of any Month
- Schedules to Refresh Data Automatically using VBA Macro
- Excel VBA Add Set of Worksheets Automatically
Recent Searches
- load excel file from other file
- automatically deleting filtered cells in excel
- excel macros to create formulas
- day formulas excel macro
- load open box using vba
- formula to find row in excell cell
- excel 2010 auto start
- maro codes for input box for data entry
- find and count data 0 to 9 in excel
- last row with data with excel vba
Popular Searches
Monthly Archives: May 2010
How to Get a Full File Path in Excel?
Ever needed to find out the full path of your current file? What I mean by full path here is the full location of the active file including the directory path and full file name. If you did, then what … Continue reading
Posted in Excel Formula, Excel VBA Function, Workbook and Worksheet
Tagged file path, fullname, Function
9 Comments
Remove Non-AlphaNumeric Characters from String
The function below will allow us to remove a non alphanumeric character from an input string. Be careful though, lengther the string, more time needed to evaluate each string on the sentence. To bad that I don’t have any idea … Continue reading