FixENTERS_File

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

CodeFunctionName What is this?

Public

Tested

Original Work

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 Mydev.net

Linkedin Login

ForFile, Optional Colo
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