| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Explode field
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Explode field
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 ..... datatext 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 "JustJo" wrote: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Explode field
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 "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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Explode field
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Explode Button to review a Formula | Setting up and Configuration of Excel | |||
| Using scale to explode a tight data set | Charts and Charting in Excel | |||
| May be Explode is the correct to do this! | Excel Worksheet Functions | |||
| VBA Function to explode string | Excel Discussion (Misc queries) | |||
| Explode Cell Data | Excel Worksheet Functions | |||
Linear Mode
