From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,100 courses taught by industry experts.

Use the Fill Justify command to quickly rewrap text into different cells

Use the Fill Justify command to quickly rewrap text into different cells - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use the Fill Justify command to quickly rewrap text into different cells

“

- [Instructor] When you've got long text entries, 2 like the one we're seeing here in cell B1 3 that's 245 characters, 4 you might want to consider rewrapping that. 5 And certainly one way to do this, not the best way, 6 would be to copy that entry into three or four cells 7 and then edit each one 8 to include only the text that we wanted to have. 9 Now, taking that text and turning it into this 10 is going to be a lot simpler 11 with a feature called Fill, Justify. 12 And let's leave this here as a reminder 13 as to what we want to do. 14 On the next worksheet over called Justify, 15 here's that same text. 16 And let's imagine that we wanted to take this text. 17 Remember, it all exists in cell B1. 18 C1, D1, E1 are all empty. 19 This has all the text right here in cell B1. 20 We can see it up in the formula bar. 21 Now, let's say that we want to rewrap this 22 to fit across this data here. 23 All we need to do…

Contents