How to put line feed in a cell using a character not Alt/Enter

[David Crowther]

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.

[Jim Rech]

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
"David Crowther" <David Crowther@discussions.microsoft.com> wrote in message
news:9A94F079-AA52-4720-9B9C-63EFDEF836CA@microsoft.com...
|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.