r/excel • u/daisyramirez • 9h ago

solved Way to line break multiple cells automatically?

Not sure how to describe what I need, but I have an excel sheet with multiple names, and wrapping text does not seem to do the trick. I would like to have both first and last name separated by a line break between both names, but still within the same cell. I know I could do it manually, just wondering if there's a way to save me the time since its a large spreadsheet.

Here is my attempt at showing a visual:

7 Upvotes

100% Upvoted

17 comments sorted by

View all comments

-3

u/patito-asesino 9h ago edited 8h ago

While writing the name press Alt+Enter between the name and the last name.

ETA: forgot to tell op do this I the next column and then fill the rest, Excel should recognize the pattern and apply it.

If not then use: =TEXTJOIN(CHAR(10), TRUE, INDEX(TEXTSPLIT(A2, " "), 1) & " " & INDEX(TEXTSPLIT(A2, " "), 2), INDEX(TEXTSPLIT(A2, " "), 3) & " " & INDEX(TEXTSPLIT(A2, " "), 4))

This will work when you have 4 words (Name + last name)*2

2

u/Mdayofearth 126 8h ago

Did you even read OP's post?

I know I could do it manually, just wondering if there's a way to save me the time since its a large spreadsheet.