I have a field that has four sets of information that I need separated.
example:
PE PS C5 270
GR HJ L6 876
I need each piece of this field in a separate field

fi f2 f3 f4
PE PS C5 270
GR HJ L6 876
I don't care if it uses a formula or VBA
Any help will be greatly appreciated. Thanks