How to Find Values in Excel With Excel's Find function, you can locate whatever you need quickly, no matter how large your workbook is. Here's how to access the tool.

Then use Find and Replace and manual editing to modify the content in each column. This is only necessary if the data in the original column is inconsistently entered or formatted.

If you want to replace the original data with the split version, select the top-left cell of the original data in the Destination field. In this example, that would be cell A2.

2. Hit "Enter" on a PC (or "Return" if you're using a Mac ) to find the first instance, and then use the arrows beside the search term to hop to the next or previous instance. 3.

Here, we're using Delimited Data, so select that option and click Next. Here, we want to choose Space, because that's what separates each data element in our list.

Image: iStock/panimoni Microsoft Excel’s Find feature is one of its most flexible tools in the entire toolbox. You can do much more than just find and replace data. For instance, you can use it ...

2. Hit "Enter" on a PC (or "Return" if you're using a Mac) to find the first instance, and then use the arrows beside the search term to hop to the next or previous instance. 3.