Skip navigation

How to write formula to create 2 columns from 1?

234 Views 4 Replies Latest reply: Oct 25, 2012 12:22 AM by Barry RSS
KGE33 Calculating status...
Currently Being Moderated
Oct 23, 2012 10:02 AM

Hello,

I am very new at using formulas in Numbers.  I have a database with a column that includes long entries describing a person's expertise.  I am trying to standardize this a bit by putting categories on the top line of each cell in that column, then using "option" "return" to separate it from the rest of the text.  If I do this, can I then use that separation to create a new column that will only pick up the first line in the first column?  I'd like to end up with a column that lists general categories of expertise which can then be sorted....

 

Thanks!

Mac Pro, Mac OS X (10.6.8)
  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 23, 2012 9:44 PM (in response to KGE33)

    Hi KG,

     

    This may do the trick:

    Picture 3.png

    Formula, in B2 and filled down column B:

    =LEFT(A2,FIND(”

    “,A2))

     

    I pressed option-return after the first quotation mark.

     

    The end of the 'category' (or in this example, the first phrase of each sentence) was also marked by option-return in the cell.

     

    Regards,

    Barry

  • Barry Level 7 Level 7 (29,095 points)
    Currently Being Moderated
    Oct 25, 2012 12:22 AM (in response to KGE33)

    The red triangle is an error flag, and comes with an error message describing (sometimes somewhat cryptically) the error that is being flagged. Knowing the error message might make it easier to explain why the formula is not working, and to offer a correction to the formula.

     

    As written, the formula will work only if your block of text is in column A and the formula is in column B.

     

    Regards,

    Barry

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.