Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Diem Tran on Nov 27 In MS Office Category.

Remove Carriage Returns

Question Answered By: Iqbal Bashara on Nov 27

If you have a string s, you could use:

s = Replace(s, vbCrLf, vbNullString)

or perhaps

s = Replace(s, vbCr, vbNullString)

depending on your source text.

vbNullString is the same as “”.

View Complete Question Thread

Didn't find what you were looking for? Find more on Remove Carriage Returns Or get search suggestion and latest updates.

Related Topics:

Copy without Carriage Return
Carriage Return within CONCATENATE function
Remove the spaces between characters in VBA
Removing a vba module or macro with another macro
Removing % sign
removing ejb's from WebLogic6.1 (w/o using console)
Trying to remove any item i've added to the copyLst
Help on Removing Duplicates in Excel
Removing macro's shortcut key
How can I set Add Remove Programs Icon
Dev Studio removes custom code when I change a page in the designer
remove configuration icon from a portlet window - liferay
remove the system console?
Removing an added Java GUI Component from an applet
PLEASE REMOVE mycroft.greatcircle.com
Macro to remove brackets
Removing the VBA SourceCode from the Workbook
To delete Rows having been assigned particular colour from selected column and / or to remove t
Remove KDE and replace with text command prompt
Removing partitions

Tagged:remove carriage returns

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us