We help IT Professionals succeed at work.

MS Excel - copying and pasting text into word doc or Notpad

When copying and pasting text from Excel into MS Word as unformated text it still includes double quotes in the text being pasted.
Is there some function like TRIM to remove the double text?
Comment
Watch Question

Author

Commented:
=CLEAN(A1) works, but I would have to fill another cell/column of cells.  Could I simple do a;
CLEAN(text) then copy it.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Hello,

I cannot reproduce that.

- select Excel cells with text and copy
- paste as "unformatted text only" into Word

No quotes.

Can you show a screenshot or the Excel source file? Is the text wrapped in quotes in Excel?

cheers, teylyn

Author

Commented:
Or could one do something like this, in one cell
"Include this text"(A2) "with this number" (A3) "with this text."

In other words, cancatenating text with cells having numbers to make one single statement like;
Include this text 100 with this number 10000 with this text.
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010

Commented:
Have you seen my post?

What do you want to achieve? Post a data sample, otherwise it will be hard to give you exact instructions.

="Include this text "&A2&" with this number "&A3&" with this text."

copy the result. Paste it to Word. There will be no quotes in Word.

Author

Commented:
Found this; =B3&TEXT(A3,"0%")
But this is my next problem, the cells (B3) is a time format:
0:00:14.12            0:00:05.50            0:00:19.62
0:00:19.62            0:00:06.02            0:00:25.64
And I get this;
"0.000134027777777778<p begin="
I need to keep this format; 0:00:14.12

Can you format the cells as Text, or do you need to do some calculation with the time values?
CERTIFIED EXPERT
Most Valuable Expert 2011
Awarded 2010
Commented:
Are you reading any of the comments here? Or are you just posting your thoughts? If the latter, I can stop posting suggestions, since you won't react anyway.

="This is a time value: "&text(B3,"h:mm:ss.00")

Author

Commented:
teylyn, sorry, I did not think that Experts would respond so quickly.  Please let me try your last suggextion.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.