LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 41
Default How Can I remove certain DATA

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
remove data connection Robby Excel Discussion (Misc queries) 0 July 3rd 07 02:12 PM
Remove Blank and Non Data Rows UT Excel Discussion (Misc queries) 3 June 12th 07 10:01 PM
comparing lists of data to remove duplicate data Tom Excel Discussion (Misc queries) 2 October 13th 05 06:16 PM
remove hidden data tamar Excel Discussion (Misc queries) 1 May 26th 05 05:05 AM
how can I remove seasonality from my data Tigger123 Excel Worksheet Functions 1 May 13th 05 06:05 PM


All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"