Remove 0D0A from cell with word

  • Thread starter Thread starter Mariusz
  • Start date Start date
M

Mariusz

In excel sheet I've got ceels with some words. At the end of every word i
got 2 chars: 0D0A and i want to delete them.
Please tell me how do that.
I tried everything, please help me !!! :(
May be someone have nice macro ?!
 
Sub ReplaceStuff()

Selection.Replace _
What:=vbCrLf, _
Replacement:="", _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
MatchCase:=False
End Sub
 
Try this formula (say your text is in A1):
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10),"")
Regards,
Stefi


„Mariusz†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Word to Excel: Export comments with text and line number 0
Text To Column max 26 characters 7
Macro for Creating Word Document!! 5
Alt codes 4
Remove Hyperlinks Without Changing background shading 14
Macro to Combine Data from Multiple Sheets with Cell References 4
Copy from Excel to Word 2

Back
Top