Remove Hard Carriage Return And Leading And Trailing Spaces

[DocAElstein]

Hello David Montoya,
I am finding it hard to understand what you are asking with this:

I am wondering if possible to have your solution, instead of hard coded for a range, to have it dynamically to be triggered by an input to a cell of the column "A", and within the range "A4:A1004"

As I understand it, the effect of this code line, .._

  If Not Intersect(Target, Range("A4:A1004")) Is Nothing Then

_.. , is to trigger, if a cell or cells in the range "A4:A1004" have its or their value changed.

( Further, the effect of this, .._

    With Intersect(Target, Range("A4:A1004"))

, _.. is to restrict action to the cell or cells which were changed. )

That sounds close to what you are asking for.
So I am confused about what you are actually wanting.
It does not take much to coinfuse me. So I may have overlooked something, or missed the point
It might be easier if you could give us a workbook with a reduced size sample, of desensitized data, to help explain what you want and / or what the problem is that you are having.

Alan

P.s. Welcome to excelfox.com :-)