MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Remove Carriage Returns

  Asked By: Diem    Date: Nov 27    Category: MS Office    Views: 1032

How would I go about removing carriage returns brought in with text?



1 Answer Found

Answer #1    Answered By: Iqbal Bashara     Answered 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 “”.

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