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
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 LoginForFile, 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,550
Downloads 1,407
CodeID
DB ID
ANmarAmdeen
692
Revisions
v1.0
Saturday
July
7
2018
Needs
Worksheet has data starting from cell A1{$CRLF$}SettingRead Settings as below{$CRLF$}Step3_File1234{$CRLF$} 1234 is the ID passed in function that setting should have an open workbook name to use (1st sheet is used){$CRLF$}Step3_CSV_Spc_ColCol6{$CRLF$} Having list of columns to fix [Enter]s in separated by +{$CRLF$} Like X+AD+AG