View Single Post
  #5   Report Post  
Kanthyd Kanthyd is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by Gary''s Student View Post
Edit Replace
type a spece in replace what
type a CNTRL-j in replace with
--
Gary''s Student - gsnu200733


"MikeMcCollum" wrote:

I want to do a find and replace a space with a carriage return in excel and
am having problems finding a way to do this
This is only replacing with carriage return within the same cell in Excel, what should be used such that the carriage return makes the text get entered in the rows below?