You're welcome
Regards - Dave.
Date: Wed, 18 Aug 2010 15:54:25 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To: excel-macros@googlegroups.com
Dave,
This worked beautifully. Thanks so much!
From: Dave Bonallack
To: "ex
Dave,
This worked beautifully. Thanks so much!
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, August 16, 2010 2:56:11 AM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
Hi Nadine,
Your original sample data had no sp
Yes and it the cell is longer than the words in the first line, the second line
appears on the first line.
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Fri, August 13, 2010 9:05:20 PM
Subject: RE: $$Excel-Macros$$ Need to remove A
Hi Nadine,
Did you format the cell with Wrap text?
Dave.
Date: Fri, 13 Aug 2010 08:46:15 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To: excel-macros@googlegroups.com
Thanks Dave. This still shows the info as all one line/sentence. I
e last one would be gone? Example below:
Entered
Test
Test2
Test3
Formula Result
Test
Test2
Test3
Thabks. Nadine
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, August 9, 2010 6:33:27 AM
Subject: RE: $$Exc
for
spaces, then applies the TRIM function which gets rid of all leading and
trailing spaces, then substitutes the remaining spaces back to CHAR(10).
Regards - Dave.
Date: Thu, 12 Aug 2010 07:20:09 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To:
est2
Test3
Thabks. Nadine
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Mon, August 9, 2010 6:33:27 AM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
You're welcome.
Dave.
Date: Mon, 9 Aug
You're welcome.
Dave.
Date: Mon, 9 Aug 2010 05:31:11 -0700
From: n8dine4ma...@yahoo.com
Subject: Re: $$Excel-Macros$$ Need to remove Alt + Enter
To: excel-macros@googlegroups.com
Thanks so much. I used the clean function and it worked perfectly. This was a
great help!
Thanks so much. I used the clean function and it worked perfectly. This was a
great help!
From: Dave Bonallack
To: "excel-macros@googlegroups.com"
Sent: Sat, August 7, 2010 10:14:21 PM
Subject: RE: $$Excel-Macros$$ Need to remove Alt + Enter
7;ll have to
experiment. (The Help calls Char(10) 'Line Feed', and Char(13) 'Carriage
Return' but they both seem to do the same thing).
Regards - Dave.
Date: Sat, 7 Aug 2010 10:12:07 -0700
From: n8dine4ma...@yahoo.com
Subject: $$Excel-Macros$$ Need to remove Alt + Enter
To:
I often receive a file that has extra Alt+Enter in it which makes the cells
long
and therefore the files long. Is there anyway I can remove these? The # rows
is 700+ - it can vary.
Thanks.
--
--
Some im
11 matches
Mail list logo
