#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2003
    Posts
    144
    Rep Power
    16

    How to do Next Line in a text in Excel reading data from SQL


    I have a long text in SQL data and wanted to display it in an excel cell with wrapping programmatically.

    What is best way to wrap the text in excel cell automatically by just reading the data from SQL?

    In SQL: qwef wefqwef qwef * retbertbertbertb

    In Excel cell:
    qwef wefqwef qwef
    retbertbertbertb

    Thanks for any help.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2016
    Location
    United Kingdom
    Posts
    9
    Rep Power
    0
    REPLACE " * " with CHR(13) for carriage return

IMN logo majestic logo threadwatch logo seochat tools logo