View original (French)

Remove line breaks Excel on Mac

Charlotte -  
Aliboron Martin Posted messages 3655 Registration date   Status Contributeur Last intervention   -
Hello,

I am using an Excel file for data merging with InDesign. I would like to remove the line breaks present in the Excel file. I tried using the ALT+010 method, and with =SUBSTITUTE(CHAR(10), "", "") and CHAR(13), but nothing seems to work.
Has anyone found a solution for use on Mac?
I am on these versions: Microsoft Excel for Mac version 16.16.13 and Mac OS High Sierra version 10.13.4
I've searched many forums, but I can't find anything... Help!!
Thank you

2 réponses

Réponse 1 / 2
Zoul67 Posted messages 2001 Status Membre 149
 
Hello,

The use of the SUBSTITUTE function should work... Are you sure you used the correct syntax?
For example: 
=SUBSTITUTE(A1,CHAR(10),"")


See you!
1
Charlotte
 
Hello and thank you for this response.
I tried, and here's what I can do:
For example, my content to clean is in A1; if I enter the formula while selecting this cell and typing =SUBSTITUTE(A1,CHAR(10)," "), the result is a window indicating that the software does not understand my request.
However, I tried selecting cell A2 (which is empty) and typing =SUBSTITUTE(A1,CHAR(10)," "), and the result is indeed the content of A1 without the line break.

Is it possible to replace the content in the original cell?
Is it possible to do multiple cells at the same time?

Thank you in advance.
0
Zoul67 Posted messages 2001 Status Membre 149
 
Hello,

Yes, the formula should indeed be placed in a cell different from A1, but... that's the basics of Excel.
For example, if you type 1 in A1 and want to make it so that A1+1 is displayed, A1 will show 2, then 3 instantly, etc.
Is it possible to replace the content in the initial cell? It’s better to use the “Replace” method, Ctrl+H... that you mentioned in your initial question
Is it possible to do multiple cells at the same time? 1. By formula, search for “Excel fill formula” in the search engine of your choice.
2. With the “replace” method (faster) by clicking on Replace All

A+
0