chima
asked on
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?
Is there some function like TRIM to remove the double text?
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
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
ASKER
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.
"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.
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.
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.
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
teylyn, sorry, I did not think that Experts would respond so quickly. Please let me try your last suggextion.
ASKER
CLEAN(text) then copy it.