Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i have Over 3000 rows of data like this:
Alain Delon 1.7 oz Eau De Toilette 15.05 Jil Sander 2.5 oz Eau De Toilette Spray 19.55 Cartier 1 oz Eau De Toilette Spray 21.70 Cartier 3.3 oz Eau De Toilette Spray 47.46 Cartier 3.4 oz Eau De Toilette Concentree Spray 48.38 Pal Zileri 3.4 oz Eau De Toilette Spray 29.38 Jessica Mcclintock 3.4 oz After Shave Soother 20.77 Nikos 3.4 oz Eau De Toilette Spray 19.55 Sergio Tacchini 3.3 oz Eau De Toilette Spray 16.78 I need to remove the Brand (i.e. Alain Delon) and the Price (last 4 digits i.e. 15.05) from all the rows Any Suggestions? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remove data connection | Excel Discussion (Misc queries) | |||
Remove Blank and Non Data Rows | Excel Discussion (Misc queries) | |||
comparing lists of data to remove duplicate data | Excel Discussion (Misc queries) | |||
remove hidden data | Excel Discussion (Misc queries) | |||
how can I remove seasonality from my data | Excel Worksheet Functions |