Little Cells Inside The Main Cell

Part of this message was posted on the Excel help forum since I asked 2 questions. The site administrator asked me to start another thread with the second question. The question seemed more appropriate for this forum -- hopefully I was correct.

On my sheet, it looks like there are 2-3 cells inside the main cell. IE: there are light cell lines inside the main cell which has dark cell lines.

Could this have happened if I converted a word document to an excel document?

I will try to post part of the workbook to show that I have the 2-3 cells inside the main cell.

However, I am not sure that the commands will work, so please be patient with me.

And, I do thank all of you for any help you can provide.

Re: Little Cells Inside The Main Cell

Hello to both RoyUK and SHG,

I apologize for my slow replies.

Regarding the "lines" inside the main cell, unfortunately you didn't see them. I will attach another sample to see if it will be more visible.

To explain this more specifically, ( and I didn't notice this at first ) the "lines" inside the main cell are row lines. However, the cell that I am calling the main cell is larger, and did have the dark borders.

I did remove the borders from the "smaller cells" -- but that didn't help my dilemma.

So in this next attachment, lines (rows) 4, 5, & 6 are supposed to be only one cell, but there is text only in 4.

7, 8, & 9 are supposed to be only one cell, but you see text on all 3 lines (rows.)

When this was converted from a Word table, each table cell was as I describe the "main cell" here.

And, incidentally, I did a long search before posting and could not find any answers. It may be that I didn't know for what to search.

I would like, also, to know what is "Word Text." It could help solve my dilemma.

Thanks again.

Re: Little Cells Inside The Main Cell

I did try to post 2-3 days ago.

It must not have taken.

Will try again.

Quote from shg

How did you copy this from Word?

Can you post the Word file?

Re: Little Cells Inside The Main Cell

Quote from shg

I see what you mean, Brandtrock, thank you. The paragraphs in the Word table cause Excel to parse those as separate cells, which results in the cells without them being merged.

I did this to fix it:

• In the table in Word, replaced all ^p (carriage return/line feed) with an unlikely combination ("|vbLf|", sans quotes)
• Copied and pasted the table to Excel
• Replaced all "|vbLf|" with vbLf (character 10). Since I don't know how to replace a string with a non-printing character in Excel from the user interface (but would like to learn if someone knows how!), I selected the table in Excel and ran this:

Code

Sub AddvbLf()
    Dim cell As Range
    For Each cell In Selection
        cell = Replace(cell, "|vbLf|", vbLf)
    Next
End Sub

Now the table is the same size and shape as in Word.

Display More

Thanks to both Shg and Brandtrock for solving the problem using Word to fix the Excel sheet.

Is it possible to fix the Excel sheet without using the Word table?

Or is that the question Shg asked? I am at a loss now since I am not a programmer.