Find/Replace in Excel

**margemynx3** · 11-27-2007, 09:39 PM

I'm moving text from a table in Word into a table in Excel. I encountered the problem of Excel not recognizing line breaks, and removed these line breaks by finding/replacing the breaks with a vertical bar.

Text is now in the appropriate cells in the Excel table. Now, I'd like to find the vertical bars and replace them with line breaks in this Excel table, so that the text doesn't run together and I get spacing similar to how it looked in the Word table.

Any ideas? I'm at a loss.

Oh and note: I have Excel for Mac.

**shg** · 11-27-2007, 11:48 PM

If it's the pipe character (124), just do Ctrl+h, Find |,
put the cursor in the Replace With, (the tricky part is coming) ...

Hold down the Alt key, and on the NUMERIC keyboard, type 010, then hit Replace All.

**margemynx3** · 11-27-2007, 11:56 PM

Thanks shg.

When I did that, it actually just replaced the vertical bars with the funny symbol created by ALT+010 (º¡º). It's like it didn't recognize it as code. Anything I might be doing wrong?

I'm not sure what the pipe character is you are talking about, maybe that's where the confusion is. A message board just told me to replace ^p with | in Word to get rid of the breaks.

**shg** · 11-28-2007, 12:18 AM

Character 10 (linefeed) is what you use to add a line break in Excel.

The ^p is used in Word Find & Replace, not Excel, to indicate a paragraph break. So if you can make the changes in Word before importing, that's great.

I don't understand the character you're seeing ...

Do you want to post an example?

BTW, are you on a PC or a Mac?