Carriage Returns - Detecting
 

Is it possible to intercept the ALT-ENTER function?

I need to be able to prevent people from doing ALT-ENTER within cells
as I extract the information into text files for reporting purposes
and as a result the data is formatted incorrect (as it see's each new
entry within a cell as a new line in the text file).

Is it either possible to not allow this, or alternatively to be able
to detect where it's been done and replace with a comma and a space?

That way I could run this macro which corrects the formatting before
the text file is created?

Appreciate your help on this. Many Thanks, Al Mackay (
)

Carriage Returns - Detecting
 

Hi,

DO a search and replace using Chr(10) as the search string.

Regards,

Jan Karel Pieterse
Excel TA/MVP

-----Original Message-----
Is it possible to intercept the ALT-ENTER function?

I need to be able to prevent people from doing ALT-ENTER
within cells
as I extract the information into text files for
reporting purposes
and as a result the data is formatted incorrect (as it
see's each new
entry within a cell as a new line in the text file).

Is it either possible to not allow this, or alternatively
to be able
to detect where it's been done and replace with a comma
and a space?

That way I could run this macro which corrects the
formatting before
the text file is created?

Appreciate your help on this. Many Thanks, Al Mackay (
)
.