Removes [Enter]s from imported csv file into Excel worksheet.
Smart enough to detect that there were [Enter]s inside certain column in worksheet that was imported from a CSV file.
Just need to specify columns where [Enter]s are expected
Needs ...
Worksheet has data starting from cell A1
Settings as below
Step3_File1234
1234 is the ID passed in function, that setting should have an open workbook name to use (1st sheet is used)
Step3_CSV_Spc_ColCol6
Having list of columns to fix [Enter]s in separated by +
Like X+AD+AG
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com
Linkedin Login
ForFile, Optional Colo
ForFile is the ID of Settings found in 'Settings' sheet to read workbook name from, see [Pre-Requirements]
ForFile is the ID of Settings found in 'Settings' sheet to read workbook name from, see [Pre-Requirements]
Views 3,554
Downloads 1,407
CodeID
DB ID
