Pasted text going into other cells

[kevs12]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have a workbook. I pasted the emails I receive from clients into my notes for them, but it bleeds into cells below. what can I do? thanks! see:
<http://tinypic.com/r/2a6t5ox/4>

 

[Bob Greenblatt]

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC

I have a workbook. I pasted the emails I receive from clients into my notes
for them, but it bleeds into cells below. what can I do? thanks! see:
<http://tinypic.com/r/2a6t5ox/4>

If that URL is supposed to give an illustration of the problem, it doesn't.
Are you pasting the email data as a picture?

 

[kevs12]

Bob, thanks.
I copy from the email, the text.
I paste into a single cell.
-- D2 for example.
I want the all text to be in only D2, but it goes into D3, D4, D5, and D6.

 

[CyberTaz]

What you're copying contains carriage returns (paragraph breaks) which
aren't allowed in a cell. If you want the entire message to go into a single
cell you'll have to paste it into a text editor (Word, TextEdit, etc) and
replace/remove all of the carriage returns (¶).

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs12]

thanks Bob, that's what I'm doing actually, pasting into Word, getting it nice.
Just with was a faster way

 

[CyberTaz]

If you aren't already doing it this way:

In Word use Find & Replace. In the Find what: field type ^p and in the
Replace with: field type a space, then Replace All. You can also record this
as a Macro to speed things up a bit more.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[kevs12]

Bob,
what is the toolbar icon I can pop on toolbar to I can see
the carriage returns (¶).

 

[CyberTaz]

In Word, that would be it. It's on the Standard Toolbar (unless you've
removed it). There is no way to display non-printing characters in Excel.

You can also use the keystroke Command+8 to toggle them on/off.

HTH |:>)
Bob Jones
[MVP] Office:Mac