Remove alt+enter in the same cell
Solved
bébéto 83
Posted messages
2
Status
Membre
-
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Vaucluse Posted messages 27336 Registration date Status Contributeur Last intervention -
Hello,
I am inputting data from a software.
In the same cell, I have the last name (alt+enter), first name (alt+enter), address (alt+enter).
In the bar next to "fx", only the last name appears.
If I widen the bar, it shows:
the last name
the first name
the address
My goal is to make the bar show:
the last name, the first name, the address
in sequence so that I can then convert this cell.
With an attachment, it would have been better, but I also don’t know how to do that.
If anyone understands and would like to help me, I thank you in advance.
I am inputting data from a software.
In the same cell, I have the last name (alt+enter), first name (alt+enter), address (alt+enter).
In the bar next to "fx", only the last name appears.
If I widen the bar, it shows:
the last name
the first name
the address
My goal is to make the bar show:
the last name, the first name, the address
in sequence so that I can then convert this cell.
With an attachment, it would have been better, but I also don’t know how to do that.
If anyone understands and would like to help me, I thank you in advance.
4 réponses
Hello
Eric is right, (hi Eric)
however we can replace line breaks with spaces or any character that will allow the conversion
To pull up the height, for example starting from A1
=SUBSTITUTE(A1,CHAR(10),"/")
which will then allow after a value copy-paste that removes the formulas, to convert based on the slash, (or any other character used in the formula)
best regards
--
To err is human, to persist is diabolical
Eric is right, (hi Eric)
however we can replace line breaks with spaces or any character that will allow the conversion
To pull up the height, for example starting from A1
=SUBSTITUTE(A1,CHAR(10),"/")
which will then allow after a value copy-paste that removes the formulas, to convert based on the slash, (or any other character used in the formula)
best regards
--
To err is human, to persist is diabolical
