Mailing list help

[ImpactCSR]

I have a mailing list that appears to have a hard return in the cell used for the street address in my mailing list.

I've tried replacing the space but this does not work. Is there a formula that I can use to remove this spacing as up until now I have had to do this manually.

Thanks

 

[Trevor G]

Welcome to the forum,

You can use a formula called Clean, but then removes all spaces, assuming this is what you want.

=CLEAN(A2)

 

[ImpactCSR]

Afraid not as the spaces between the street# and name are then removed.

It lloks like this right now in the cell.

123 Main St
Ste 1

and it needs to look more like this:

123 Main St Ste 1

Thanks for the help!

 

[VoG]

Try

=SUBSTITUTE(A1,CHAR(10)," ")

If that doesn't work try CHAR(13)

 

[ImpactCSR]

Thanks a million!

You have saved me hours of work and at least a few Motrin