How about neither...
Go to the Data menu and find "Text to Columns"
'--

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"JustJo"
wrote in message
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