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 Shortcut:??? No Line Breaks in Cell

Select the range to fix
Edit|Replace
what: ctrl-j
with: (spacebar)
replace all

ctrl-j is the same as the alt-enter (or alt-0010 from the numeric keypad).

" wrote:

Oh my gosh, so I have made a excel document containing about 140 rows
for a ecrater bulklister.

The point of the bulklister is so I can list all of my items on
eCrater(free ebay) without having to do it one by one.

The problem is that in my Items Description I have included line breaks
so the listing will look organized.

My bulklister has been rejected because of these line breaks.

Is there a short cut to get rid of my line breaks so I don't have to do
it manually?

--


--

Dave Peterson