Google Sheet: Line Break within a Formula
consgab
Posted messages
6
Status
Membre
-
Yoyo01000 Posted messages 1720 Registration date Status Membre Last intervention -
Yoyo01000 Posted messages 1720 Registration date Status Membre Last intervention -
Hello,
Inside a cell, I have a long formula that I would like to automatically wrap to the next line at each "+" for better readability.
I would like this image:
To become this image automatically:
Without having to do an Alt+Enter manually each time
Is it possible?
Thank you in advance for your help :)
Inside a cell, I have a long formula that I would like to automatically wrap to the next line at each "+" for better readability.
I would like this image:
To become this image automatically:
Without having to do an Alt+Enter manually each time
Is it possible?
Thank you in advance for your help :)
1 réponse
Hello, if this is the final formula, an Alt+Enter won't cost you much.
And if this formula needs to be in other cells, dragging the one that has line breaks will do the trick.
You can enter "Marianne" in a cell (for example in Z2) and then reference that cell in the formula like this:
...!$I:$I;$Z2)
If there need to be other first names, list them in another cell afterwards.
If you drag the formula vertically: place the first names vertically
If you drag the formula horizontally: place the first names horizontally
--
Remember to say "thank you" and "resolved" when the issue is.
And if this formula needs to be in other cells, dragging the one that has line breaks will do the trick.
You can enter "Marianne" in a cell (for example in Z2) and then reference that cell in the formula like this:
...!$I:$I;$Z2)
If there need to be other first names, list them in another cell afterwards.
If you drag the formula vertically: place the first names vertically
If you drag the formula horizontally: place the first names horizontally
--
Remember to say "thank you" and "resolved" when the issue is.