![]() Snake columns has an examples of possible interest. ![]() Column C is not checked for but just mirrors what isĪpplication.Calculation = xlCalculationManualįor i = Cells(, "A").End(xlUp).Row _ Splitting up some lines with LF into separate rowsĭon't know what you want to do about Column A when you split upĬolumn B. To test a single byte - remove part in front before testing. If macro doesn't split properly, use CODE worksheet function It is possible that you have CHR(13), CHR(10), or CHR(13)&CHR(10) You may have to verify that it is linefeed character separating lines CRLF - Lines Split by Carriage Return, Line Feed CRLF - Lines Split by Carriage Return, Line Feed Location: Home page: Determining what character(s) is used
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |