Combine tab separated values with comma Macro (v11.0.2)

[hemicyon]

Copy a range of cells from excel and paste individually using find and replace in pages

That would be because the values from Excel are separated by CR or LF, not by a TAB: [image] It is always best to develop/confirm any RegEx using Regex101.com (or similar tool) We could write a RegEx for a specific number of Excel cells, but it might be better to write a more comprehensive macro to handle a variable number of cells, something like this: Here is an EXAMPLE macro to give you some ideas. You will need to modify to suit you specific workflow. Please let us know if this works …

According to this post, Excel values aren't separated by tabs. So I tried using \n instead and it adds commas between the cell values, but it also adds a comma after the last value too. I'm sure there's a way to fix that though.