Reply to thread

Message: [QUOTE="Jim Rech, post: 2873285"] If I'm following you here's an example macro that replaces each space in a cell with a line feed character. Sub a() Dim Cell As Range For Each Cell In Selection.Cells Cell.Value = Replace(Cell.Value, " ", Chr(10)) Next End Sub -- Jim |I need to import a csv file into another application and as there are a lot | of lines I need to be able to do a find and replace of a symbol to a line | field. This means I have a string of data in a cell and I want to get the | cell with the line feed back into it. [/QUOTE]