[Solved] Cell widths are different in one column

[fzrules]

I have a Calc sheet where data was imported from a website.
The columns are all the same width, but some of the cells have become merged with adjacent cells so they are 3x the width of standard cells.
I can do a "format/merge cells" to make them the same size, but I have MANY cells that need this done. Is there a shortcut?

Using iOS 10.15.7
Open Office 4.1.11

I have attached screenshot as I can't figure out how to insert it into my message.

Thanks!

[Bill]

What are you trying to accomplish by merging cells? If you're trying to align the data in row 109 with data in other rows, I don't see how that can be done by merging cells. It can be done by unmerging cells in row 109 then deleting some cells.

[Hagar Delest]

I think that the issue is that the cells have been merged by the paste operation, not by OP.

I'm not an expert in Calc. Have you tried to paste special so that it imports the clipboard without the HTML formatting of the page?

[fzrules]

Thank you Hagar! Pasted as Unformatted Text.
That did it!