Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
The figures below relate to horseracing form which are contained within one
column. I wish to ignore the symbols '-' and '/'. 15P-P7 253-31 2F-6PP 271-21 218-23 41F7-7 9F6-23 583F-0 /2P4-1 /2-6P3 33-41P 3PP1/3 42-333 How can I extract the last three items so that they are presented in three different columns, as set out below? P P 7 3 3 1 6 P P etc. TIA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selective extraction of data | Excel Discussion (Misc queries) | |||
data extraction | Excel Discussion (Misc queries) | |||
data extraction | New Users to Excel | |||
data extraction from excel | New Users to Excel | |||
Data Extraction | Setting up and Configuration of Excel |