Excel 2008 carriage return

[=?Utf-8?B?Sm9XaWxsbW90dA==?=]

I have data that I would like to store in an excel spreadsheet. It's
currently in a Word table. The problem is that each line has some cells that
split over several lines. If I copy and paste it as is, the data split over
lines get put into separate rows. I have partly solved this problem by
replacing the paragraph mark (^p) in Word with a tilde (~). Now the rows are
as I want them. But I want to replace the tilde in Excel 2008 with a carriage
return. I know that to enter carriage returns manually I use Alt + Enter. But
I cannot work out how to express that in the Find and Replace dialog. I have
tried searching for answers to this question, but have had no luck so far. If
anyone can help I would be very grateful.
Many thanks,
Jo

[Jan Hyde (VB MVP)]

JoWillmott <Jo********@discussions.microsoft.com>'s wild
thoughts were released on Tue, 19 Aug 2008 03:28:03 -0700
bearing the following fruit:

>I have data that I would like to store in an excel spreadsheet. It's
currently in a Word table. The problem is that each line has some cells that
split over several lines. If I copy and paste it as is, the data split over
lines get put into separate rows. I have partly solved this problem by
replacing the paragraph mark (^p) in Word with a tilde (~). Now the rows are
as I want them. But I want to replace the tilde in Excel 2008 with a carriage
return. I know that to enter carriage returns manually I use Alt + Enter. But
I cannot work out how to express that in the Find and Replace dialog. I have
tried searching for answers to this question, but have had no luck so far. If
anyone can help I would be very grateful.
Many thanks,
Jo

I think your question would be better asked in an Excel
group rather than a dotnet programming group.
--
Jan Hyde (VB MVP)

https://mvp.support.microsoft.com/profile/Jan.Hyde