Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Re: [BI] Delete Carriage return query

Nov 13, 2007, 1:16 AM
theryall
New User (1 post)
Nov 13, 2007, 1:16 AM
Views: 68151
Shortcut
Quote Reply
Re: [BI] Delete Carriage return query In reply to
Morning,

I doubt that the originator of this thread is losing sleep over it these days, but I've found a solution that works for me and Office 2007:-

Copy the cells into Word. Within Word, within the "Find and Replace" dialogue select the "Special" menu & select "Manual Line Break".

Worked for me and I think should work with any Word which has a "Special" menu within its Find function.

Sam.
Subject Author Views Date
Thread Delete Carriage return query Mad_Mick 90773 Jan 18, 2004, 7:10 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		Andy 90416 Jan 19, 2004, 2:48 AM
Post Re: [Andy] Delete Carriage return query 		Mad_Mick 90189 Jan 19, 2004, 2:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		llccoo 90264 Jan 25, 2004, 9:23 AM
Thread Re: [llccoo] Delete Carriage return query 		Mad_Mick 90291 Jan 26, 2004, 1:52 PM
Post Re: [Mad_Mick] Delete Carriage return query 		Watts 90187 Jan 26, 2004, 3:36 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		llccoo 90181 Jan 26, 2004, 3:43 PM
Thread Re: [llccoo] Delete Carriage return query 		Mad_Mick 90171 Jan 26, 2004, 4:34 PM
Post Re: [Mad_Mick] Delete Carriage return query 		llccoo 90139 Jan 27, 2004, 4:17 AM
Thread Re: [Mad_Mick] Delete Carriage return query 		Watts 90169 Jan 28, 2004, 9:39 AM
Post Re: [Watts] Delete Carriage return query 		llccoo 90163 Jan 28, 2004, 8:45 PM
Thread Re: [Mad_Mick] Delete Carriage return query 		KarlS 86653 Jul 8, 2005, 11:49 AM
Thread Re: [KarlS] Delete Carriage return query 		BI 86455 Jul 26, 2005, 3:17 AM
Post Re: [BI] Delete Carriage return query 		theryall 68151 Nov 13, 2007, 1:16 AM
Thread Re: [Mad_Mick] Delete Carriage return query 		justin.kearney 65912 Feb 29, 2008, 7:01 AM
Thread Re: [justin.kearney] Delete Carriage return query 		LaLa 63234 Jun 24, 2008, 4:47 PM
Post Re: [LaLa] Delete Carriage return query 		justin.kearney 63141 Jun 25, 2008, 5:37 AM