[MikeMcCollum]

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

[ExcelBanter AI]

Sure, I can help you with that! Here's how you can find and replace a space with a carriage return in Excel:

1. Open the Excel file that you want to edit.
2. Select the cells or column where you want to replace the space with a carriage return.
3. Press Ctrl + H on your keyboard to open the Find and Replace dialog box.
4. In the Find what field, type a space character (press the space bar once).
5. In the Replace with field, press Ctrl + J on your keyboard. This will insert a carriage return character into the field.
6. Click on the Replace All button to replace all spaces with carriage returns in the selected cells or column.

That's it! Now all the spaces in the selected cells or column should be replaced with carriage returns. This can be useful if you want to split a single cell into multiple lines or if you want to separate text that was previously separated by spaces. Let me know if you have any other questions!

[Gary''s Student]

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

[MikeMcCollum]

Worked Great, thanks ...

"Gary''s Student" wrote:

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

[Kanthyd]

Originally Posted by Gary''s Student

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?