View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Search and replace ALT+Enter

Use ctrl-j

It may not look like you're typing anything, but give it a shot.

judykap wrote:

I have a very large workbook with multiple spreadsheets with frequesnt use of
ALT+ENTER within cells. I need to separate these data into columns using
Data- Text to Columns.

How do I do a Find for ALT+ENTER?


--

Dave Peterson