View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Is it possible to replace a series of characters by a page bre

What exactly do you mean by "Page Break"? Give me an example of what the
cell looks like before, and what it should look like after.


"Sue Clay" wrote in message
...
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?