Results 1 to 14 of 14

Removing Partial Data From Columns

Threaded View

  1. #1
    Registered User
    Join Date
    06-30-2010
    Location
    Bucharest, Romania
    MS-Off Ver
    Excel 2007
    Posts
    26

    Question Removing Partial Data From Columns

    I would be very grateful if someone could help me find a solution.

    I have a spreadsheet with a couple thousand entries.

    When I first began, years ago, in one column, I used to enter the item and cost but now I have found it much better if I use a seperate column for costs and so basically, I want to highlight the entire column and remove only the prices.

    To give you an illustration:

    Teddy - £5
    Book - £2
    Coffee Table
    Book

    To be more precise, I would actually want to get rid of the ' - £5' and be left with only 'Teddy'.

    Any help would be greatly appreciated, thanks.
    Last edited by pwell; 06-30-2010 at 07:17 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1