Good afternoon all,

This is my first post as I am new to the forum

I am looking to split multiple different entries in a single cell into multiple columns and repeat this for all rows

Example (I have the below in a single Cell as column headers)
NCM Server Mgmt VLAN Site ID

Next Line down is the data (Each row in a single cell)
Enabled 10.10.10.0 50 TEST SITE 1
Enabled 10.10.20.0 50 TEST SITE 2
Disabled 10.10.30.0 50 TEST SITE 3


I have very little experience with Excel and VBA as this is not my normal job (Network Engineer) but this would help me out loads if I could acheive this as I have a number of projects where this would become useful

I know you can use delimeters but with spaces between the values I just can't fathom a way forward


Any assistance appreciated


Thanks
David