Clearing the carriage returns in a cell with text

Good morning!

So I have a report that I work on every month. This report pulls data from our Oracle database. Some of the columns represent free text fields within an Oracle form. If the enter key was hit when a tech was entering data, it pulls over to this report. How can I trim or remove those extra characters without losing the text within that cell? I want to to create a code for this to incorporate within my existing formatting code. I have attached an example of this for you assistance to resolve this.

That didn't seem to do the trick.

General,

I'd rather use a macro because of all the other formatting, I would like to include this with the other formatting.

General,

I tried using the code that Steffen provided, I did not try your method. Yes, I have noticed that before and that is why I have been trying to create this code prior to me entering the cell. I tired to run the macro code before doing anything within any of the cells and yet is still does not get rid of that return.

The report I am working on is a rather large and detailed report for the customer. The more I can do with a macro the better. So if I can remove this return within the cells with a macro during the other formatting procedures, that would be AWESOME!!!

Any ideas?

Steffen,

That didn't work either.

So why doesn't that work in my code?

these are the codes I am using...

Please Login or Register  to view this content.

I don't get it?!?!?!

When this code runs, it counts the carriage return as a character and doesn't result that same as if I just enter in the formula into a cell. The code does not remove the carriage return.

Here is an updated worksheet that I am working with. The yellow cells are the cells that have the carriage returns that will not go away.

This is what I did with the code..

Please Login or Register  to view this content.

But it didn't work...ideas?

if I use that short code, do I just need to place

Please Login or Register  to view this content.

after my declarations and before the shortened code?

Awesome!! It works now! I have no idea what I was doing before that was causing this not to work but we are good now!!!

THANKS!!!