+ Reply to Thread
Results 1 to 2 of 2

Selecting individual items from column to create new set of figures

  1. #1
    Registered User
    Join Date
    07-29-2010
    Location
    Gympie, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Selecting individual items from column to create new set of figures

    I have a column which contains the following type information

    2100 X 750

    What I want to convert this into is two columns -
    the first which would pick up only the 2100
    the second which would pick up only the 750
    I would then create a third column which would multiply the two.

    Does anyone know how I can create the 1st and 2nd columns using a formula?
    Last edited by wawalke; 08-01-2010 at 10:31 PM.

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Selecting individual items from column to create new set of figures

    Hi wawalke
    Welcome to the forum
    these three will do the trick
    =LEFT(A1,SEARCH("X",A1)-1)
    =MID(A1,SEARCH("X",A1)+1,100)
    =B1*C1
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

+ 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