+ Reply to Thread
Results 1 to 2 of 2

Line breaks in a cell

  1. #1
    Registered User
    Join Date
    09-23-2011
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question Line breaks in a cell

    What I am trying to do is export data from a program into excel. This will have 500 rows. Each cell has several lines of data in that one cell that are separated by a line break. I then need to save that excel in csv format and upload it back into the program. The problem I am having is once I upload this the line breaks are now gone. I know I can do alt enter at each line break but is there some way to do this in bulk with a formula or something.

  2. #2
    Forum Contributor
    Join Date
    09-13-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    216

    Re: Line breaks in a cell

    You can always use the Char(10) or Char(13)

    This will add line breaks.

    Perhaps something like this: =G8&CHAR(10)&char(13)"hello"

    Steve=True

+ 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