Vista - Excel 2008 carriage return

08-19-2008

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

08-19-2008

JoWillmott <JoWillmott@xxxxxx>'s wild
thoughts were released on Tue, 19 Aug 2008 03:28:03 -0700
bearing the following fruit:

Quote:

>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

08-19-2008	#1 (permalink)
JoWillmott n/a posts	Excel 2008 carriage return 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
My System Specs

08-19-2008	#2 (permalink)
Jan Hyde (VB MVP) n/a posts	Re: Excel 2008 carriage return JoWillmott <JoWillmott@xxxxxx>'s wild thoughts were released on Tue, 19 Aug 2008 03:28:03 -0700 bearing the following fruit: Quote: >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
My System Specs

Similar Threads
Thread	Forum
Avoid "carriage return" in text file	PowerShell
Preserve carriage returns in RichTextBox control	.NET General
Add-Content and carriage returns	PowerShell
Excel 2007 Problem with 2008 Calendar	Vista General
Carriage return problem in output	PowerShell