Cell merge/formatting (Excel/Word XP)

Topic

New Reply

I don’t know if this is a Word or Excel question. I have an Excel spreadsheet and am trying to convert the cells to text so I can paste it into Crystal Reports. I’m copying the cells from Excel into Word and then doing a Merge Cells to get rid of the lines. Is there a way to do this but have it place tab stops where the table lines were so I don’t have to reformat all of it to look the same (without the cell lines)?

Reply | Quote

Replies

You can export to a tab-delimited text file directly from Excel (File | Save As…)
Or you can paste the table into Word, select the entire table, then select Table | Convert | Table to Text…, and specify Tab as delimiter.

Reply | Quote

You can export to a tab-delimited text file directly from Excel (File | Save As…)
Or you can paste the table into Word, select the entire table, then select Table | Convert | Table to Text…, and specify Tab as delimiter.

Reply | Quote

I’m sorry if I’m being thick here, but is what you want to do just to paste a block of information into Crystal without the lines that Excel puts round it? Because if so, you’ve only got to remove the lines in Excel before copying and then paste the block in …

I assume I must be missing something here? If so, please let me know what exactly you want to do in Crystal and I’ll try again …!

Reply | Quote

I’m sorry if I’m being thick here, but is what you want to do just to paste a block of information into Crystal without the lines that Excel puts round it? Because if so, you’ve only got to remove the lines in Excel before copying and then paste the block in …

I assume I must be missing something here? If so, please let me know what exactly you want to do in Crystal and I’ll try again …!

Reply | Quote