View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sue Clay[_2_] Sue Clay[_2_] is offline
external usenet poster
 
Posts: 7
Default Is it possible to replace a series of characters by a page bre

Thanks for the response. Tried it, but instead of replacing with page break
- it gave me a larger cell size. Odd. On this machine, I'm using version
2000. Would that be my problem?

"PCLIVE" wrote:

Use Replace from the Edit menu.
For Replace with, hold Alt and type 010.

HTH,
Paul

"Sue Clay" wrote in message
...
Ok - make that "I'm importing data ... "

"Sue Clay" wrote:

I'm important data from a text file and would like to be able to
automatically replace a pre-set series of characters (say, $$$$) by a
page
break. Is this possible?