View Single Post
 
Old 08-01-2022, 08:26 AM
kilroyscarnival kilroyscarnival is offline Windows 10 Office 2021
Expert
 
Join Date: May 2019
Posts: 346
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

I have the same question as Arvi above.

I've made an example where some entries are typed in two different cells/rows, and some are just broken with the ALT+Enter to show up on a second line in the same cell.

In the first example where they are in two different cells, you can use a Concatenate formula to combine the contents of the two cells, and in this case, adding the comma and space in between them.

In the "Peppermint Patty" example, I used Find/Replace, and in the Find cell I typed a CONTROL+J, and replaced with the comma and the space. It eliminates the manual line break in the Excel cell.

Another method entirely if you have a lot of those line breaks within the cell would be to transform your document in PowerQuery if you have it. There's a command in there which would make it easy to remove those line breaks. I have PowerQuery within Excel 365 for Windows but I don't know anything about the Mac side.
Reply With Quote