Hi!

I am having problems in VB/Excel, on how to deal with multiple lines in a cell. Some cells contains more than one line within a cell and I need to either delete the other line or concatenate all characters to a single stream of characters using VB Code

Also, I need to do the following:

1. Replace all the character "Ñ" to "N"
2. Delete all hidden columns and rows
3. Number format. Amount fields should not contain any commas

Please help me!!!

I need to consider these points before i convert my excel file into .CSV format


Thanks