+ Reply to Thread
Results 1 to 2 of 2

Excel 2003 Formulas ?

  1. #1
    MAC
    Guest

    Excel 2003 Formulas ?

    Excel 2003,
    Hi,
    After creating a formula to extract data from various cells to put into one
    ie:
    ="Name: "&A2&", Surname: "&B2&", Age: "&C2

    * I would like to delete the cells which I don't need anymore however I lose
    data from the cell that I've applied the above formula to as it loses its ref
    - is there a way around this ?

    Thanks for your time to my query.
    Regards,
    MAC



  2. #2
    Registered User
    Join Date
    01-05-2006
    Posts
    65
    copy the cells with the name, surname, age. Go to edit->paste special->values
    and paste those cells into a new column. Delete the column with the formula
    and then you can delete any of the other cells that you need to.

+ Reply to Thread

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