Announcement

Collapse
No announcement yet.

Line Feed within String Formula (Not Manual or VBA)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Line Feed within String Formula (Not Manual or VBA)



    Okay, I know how to manual line feed within a cell (Alt+Enter) and I know how to do with the code.

    What I'm after is a line feed within a cell using a string formula, for example:

    =A2 & chr(10) & B2 & chr(10) & C2
    Barbara - aka The Cat Lady

    Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

  • #2
    Re: Line Feed within String Formula (Not Manual or VBA)

    Do you mean on a worksheet?

    This should work if you turn on word wrap in the cell with the formula.

    =A2 & CHAR(10) & B2 & CHAR(10) & C2
    Boo!

    Comment


    • #3


      Re: Line Feed within String Formula (Not Manual or VBA)

      Originally posted by norie
      =A2 & CHAR(10) & B2 & CHAR(10) & C2
      Yeppers, that works -- just 1 little letter more than in VBA's chr(10), duh!

      Thanks Norie.
      Barbara - aka The Cat Lady

      Please do not U2U (private message) me directly for questions that should be posted to the forum; any such U2Us, unless requested by me, will be deleted.

      Comment

      Working...
      X