Is there a VBA script/ formula to have cells that have data with spaces separate the data into new cells discarding the spaces?

Viewed 20

I would like to know if there is a script or function in excel such that when I enter in data into a cell that looks like this,a b c. It will split the data into three cells as such, a, b and c. And it will do this for the entire string of data.

0 Answers
Related