Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How To Split Words Into Separate Cell In Excel?

Date:2022-3-27 Author:Sandra

Today, we are going to learn a very easy but useful trick how to split words into separate cells. A case in point is the following picture.

There are roughly 30 name words in cell A1. Now we need to divide these words into separate cells.

Press Ctrl and H to quickly open the Find and Replace window.

How To Split Words Into Separate Cell In Excel?

Enter[,]in Find what box, and press Ctrl and J after selecting Replace with box.

How To Split Words Into Separate Cell In Excel?

Then, hit Replace All. The names turned into a list in cell A1.

How To Split Words Into Separate Cell In Excel?

Select all the names and press Ctrl and C to copy them.

How To Split Words Into Separate Cell In Excel?

Press Ctrl and V to paste these names into separate cells. Got it!

How To Split Words Into Separate Cell In Excel?
Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *