Problem: Copying a cell that contains line breaks adds extra quotes

B

brian.caines

Hey guys, I'm having this issue when trying to copy a cell that
contains line breaks.

Here's how it's set up: Cells on the left contain various info, one
cell on the right uses =CONCATENATE to concatenate them together into
one cell (with quotes around each value). One of the cells on the left
contains multiple lines, separated by line breaks.

The formula that concatenates them together does display the line
exactly as it should look, but when I copy and paste that into a .txt
file, it adds quotes around every value, and quotes around the entire
cell. Anyone know a way around this issue? I found a similar issue
here:

http://groups.google.com/group/micr...st&q=line+break+quote&rnum=3#f94e622b47db0c01

but I could not respond to that. Any info is greatly appreciated,
thanks!

Brian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Random table of data - need to find every cell that contains specific data 1
Wrapping text with line breaks problem 1
I want to copy cell from word that includes line breaks to excel 1
Problem Cutting and Pasting from SQL Table to Excel Sheet 0
How to get intermediate value of cell formula 1
Special Character at End of Each Table Cell 2
Concatenate and Line Breaks 1

Top