Penny Arcade Forums› Games and Technology
The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.

excel question

redfenixredfenix Aka'd as rfixRegistered User regular
edited April 2008 in Games and Technology
I'm trying to set up a 3-line block of text in a single cell, referenced from 3 other cells via functions, so that i can then copypasta the values into a table that will end up going into a website.

Problem is, when i use alt+enter to do manual line breaks within a cell, the functions try to form an equality, instead of being distinct functions.

EX:

=C2
=D2
=E2

it gives me the result of FALSE, because i can't manually terminate the function
help?

9vjk4kkjpxoz.png
SE++ Map Steam
redfenix on

Posts

  • PemulisPemulis Registered User regular
    edited April 2008
    I don't have the solution, but I don't think this has anything to do with the line breaks. What you have above wouldn't work if there were spaces instead of line breaks either.

    Pemulis on
  • RookRook Registered User regular
    edited April 2008
    I don't think you can.

    Rook on
  • TyrantCowTyrantCow Registered User regular
    edited April 2008
    Yeah...
    I'm no excel guru (I've used it quite a bit); but, I think I'm with Rook on this one.
    I don't think you can execute multiple functions in a single cell.

    TyrantCow on
    MooMan
  • ErchamionErchamion Registered User regular
    edited April 2008
    Use 3 cells. I don't know that there isn't some magic way to put values in 3 different cells from one, but it would be a lot easier to just use all 3 instead of trying to figure out how to populate from one.

    Erchamion on
    veldyr.pngSteamID
  • CmdPromptCmdPrompt Registered User regular
    edited April 2008
    Use:

    =C2 & "
    " & D2 & "
    " & E2

    Putting in line breaks between "s.

    CmdPrompt on
    GxewS.png
  • PemulisPemulis Registered User regular
    edited April 2008
    Wow, nice work!

    Pemulis on
  • EleazarDMMEleazarDMM Registered User regular
    edited April 2008
    You can use

    =B5&CHAR(10)&B6&CHAR(10)&B7

    and it works just like

    =B5&"
    "&B6&"
    "&B7

    but either method requires that you turn "word wrap" on in the cell properties, or you'll get the black boxes instead of carriage returns.

    EleazarDMM on
    E N G I N E E R
  • RookRook Registered User regular
    edited April 2008
    Nice guys, learn something new everyday :)

    Rook on
  • ToyDToyD Registered User regular
    edited April 2008
    Another way is to insert an apostrophe at the beginning of the text. such as '=B1 Alt+Enter =B2 Alt+Enter =B3 and the displayed text will only be the =B1 =B2 =B3 on seperate lines. The apostrophe will show in the formula bar (not sure if it will show in the .Value option of the cell code or not) but it displays correctly without trying to calculate.

    ToyD on
    steam_sig.png
  • polikupoliku Registered User regular
    edited April 2008
    I didn't come here expecting to learn some excel tricks, but damn, I've been wondering how to do something similar (combining values into a single cell) for awhile.

    <3<3:mrgreen::rotate:

    poliku on
  • scarescare Registered User regular
    edited April 2008
    EleazarDMM wrote: »
    You can use

    =B5&CHAR(10)&B6&CHAR(10)&B7

    and it works just like

    =B5&"
    "&B6&"
    "&B7

    but either method requires that you turn "word wrap" on in the cell properties, or you'll get the black boxes instead of carriage returns.

    Most spiffy, I didn't know about the char() function.

    scare on
    mister_fej.png
Sign In or Register to comment.
Penny Arcade Forums› Games and Technology