[mso] Re: Macro in Excel to Remove CR/LF

Dave, I'm not sure now whether it's a return or a CR/LF.  I will create
a file with just the headings and will put in the files area.  I don't
have access to the files area from work, so I will send it home and put
it up there tonite.  I appreciate any help as this is really an annoying
problem.

Thanks,

Christine McDonald
Technical Specialist
Western Regional Office

Remember when life's path is steep to keep your mind even.



IMPORTANT: This e-mail, including all attachments, constitute Federal
Government records and property that is intended only for the use of the
individual or entity to which it is addressed.  It also may contain
information that is privileged, confidential, or otherwise protected
from disclosure under applicable law.  If the reader of this e-mail
transmission is not the intended recipient or the employee or agent
responsible for delivering the transmission to the intended recipient,
you are hereby notified that any dissemination, distribution, copying or
use of this e-mail or its contents is strictly prohibited.  If you have
received this e-mail in error, please notify the sender by responding to
the e-mail and then delete the e-mail immediately.



-----Original Message-----
From: Dave Sharpe [mailto:DaveSharpe2@xxxxxxx]=20
Sent: Friday, April 23, 2004 4:47 PM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Macro in Excel to Remove CR/LF


Christine

The heading says that you have CR/LF but the verbage
is just mentions "returns".

Can You send Me a sample
[ off group davesharpe2@xxxxxxx ]
so that I can be sure I'm working with the actual
problem ?

Dave


----- Original Message -----=20
From: "McDonald, Christine, Ms, DCAA" <Christine.McDonald@xxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Friday, April 23, 2004 7:06 PM
Subject: [mso] Macro in Excel to Remove CR/LF


I have data in an Excel file that comes in from another system.  It puts
returns in the header to wrap the header and single line headers have
two returns before the text so that they are vertically aligned bottom.
When I bring it in, the returns are there, which causes problems when I
sort, because it displays blank information in the sort window, since it
sees the first line, which blank. I tried to record a macro to remove
them, but because I am editing the cell when I do it, it replaces the
text in each cell I run the macro on, with the text in the cell where I
recorded the macro.  I tried modifying the macro after recording, but
couldn't figure out how to tell it to leave the current text, just
remove those returns.

Would it be possible to write a macro that would go into each cell and
remove the returns, replace them with a single space and retain the
text?

Thanks,

Christine McDonald
Technical Specialist
Western Regional Office

Remember when life's path is steep to keep your mind even.




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx
or MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to=20
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the
quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will
also allow you to change your email settings to digest or vacation (no
mail). http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group,
send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
invitation with instructions.  Once you are a member of the files group,
you can go here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: