Forum Discussion
CrispLaundry
Jan 29, 2024Copper Contributor
combine 2 lines in 1 cell into 1 line
example cell 1: 34 Gladstone St Kogarah I Want to change it to 34 Gladstone St, Kogarah I use Mac not windows Thanks, Nina / http://www.crisplaundry.com.au
CrispLaundry
Jan 29, 2024Copper Contributor
can you please check my message again? i edited it
HansVogelaar
Jan 29, 2024MVP
Almost the same:
Select the cell or cells in which you want to do this.
Press Control+H or Command+Shift+H to activate the Replace dialog;
Click in the 'Find what' box and press Control+J (I don't know if this works on Mac). It will seem that nothing happens, but you're entering the invisible line break character. Or enter a line break in a cell and copy it, then paste it into the 'Find what' box
Click in the 'Replace with' box and enter a comma followed by a space.
Click 'Replace All'.
- CrispLaundryJan 30, 2024Copper Contributorthere isnt an option for mac for ctrl + J, how do i do i enter a line break in a cell and copy it?
- HansVogelaarJan 30, 2024MVP
I don't have a Mac. I hope someone else can answer this.