Explode field

[JustJo]

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

 

[FSt1]

hi
if the set of information have spaces, i would recomend that you use text to
columns.
high light the range(column) you wish to parce.
on the menu bar .....
data>text to columns...
first screen, check delimited
second screen, check space
third screen, ignore, check finish.
done.
make sure that you have 3 empty columns to the right of the data sets
because this feature will overright any data to the right.

Regards
FSt1

 

[Rick Rothstein \(MVP - VB\)]

When you say "field", you mean "cell", right? Highlight your cells, click
Date/TextToColumns on Excel's menu bar and when the dialog box comes up,
click the Delimited option button, then Next, click in the Space check box
and then click Finish.

Rick

 

[Jim Cone]

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