So i received this database that contains all the information ins the Column A, what my boss wants me to do is to separate them, for example the item description in cell A1 is :
TS160H ATU160 125A 4P3D EXP
This is the code for the product, each description separated by a space in the cell. So i'll have to put TS160H in column B1, ATU160 in column B2, 125A in column B3, 4P3D in column B4, and EXP in column B5.
But the database is over 4,000 rows and it would take me all day if i manually separated all of them. Is there a macro for this?
Thanks in advance.
Bookmarks