Using the Text to Columns Tool . One way to split data into multiple columns in Microsoft Excel is to use the built-in Text ...

In case you have a list arranged across a column, you can replicate the formula across the list using the Fill option. Add a comma after the first word in each cell in Excel using Replicate ...

If you want to add parentheses in Excel, here is how you can do that ... Then, select the entire column of extracted numbers and press Ctrl+C to copy. Once done, keep the same column selected ...