Imported Data: Replace Non printable character with a space

I have some alphanumeric data imported from a Database. If the user hits the "enter" key when they type the text into this DB, I end up with a 'square' ie looks like CHAR(10) within the text.

If I use the Clean function it gets rid of it but I need to replace it with a space. I have also tried doing a replace, but can't "Find" the character

Does anyone have any suggestions?

Thanks

Karen

Try this, Karen:
http://vbaexpress.com/kb/getarticle.php?kb_id=579
Seems to be just what you need.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"ksp" <[email protected]> wrote in message
news:[email protected]...
>
> I have some alphanumeric data imported from a Database. If the user hits
> the "enter" key when they type the text into this DB, I end up with a
> 'square' ie looks like CHAR(10) within the text.
>
> If I use the Clean function it gets rid of it but I need to replace it
> with a space. I have also tried doing a replace, but can't "Find" the
> character
>
> Does anyone have any suggestions?
>
> Thanks
>
> Karen
>
>
> --
> ksp
> ------------------------------------------------------------------------
> ksp's Profile:
> http://www.excelforum.com/member.php...fo&userid=6267
> View this thread: http://www.excelforum.com/showthread...hreadid=516763
>

Hi Anne

yes it's solved my issue

Thanks for that

Karen

You're welcome!

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"ksp" <[email protected]> wrote in message
news:[email protected]...
>
> Hi Anne
>
> yes it's solved my issue
>
> Thanks for that
>
> Karen
>
>
> --
> ksp
> ------------------------------------------------------------------------
> ksp's Profile:
> http://www.excelforum.com/member.php...fo&userid=6267
> View this thread: http://www.excelforum.com/showthread...hreadid=516763
>