+ Reply to Thread
Results 1 to 2 of 2

Iu-line Display of Text in a Cell

  1. 03-23-2017, 08:38 AM #1
    trav1
    trav1 is offline
    Registered User
    Join Date
    03-15-2017
    Location
    Miami, FL
    MS-Off Ver
    15.32 (Office 365)
    Posts
    10

    Iu-line Display of Text in a Cell

    Hello All,

    I am working with the following data:

    A1: NYC-DEN-SEA

    B1: NYC
    B2: DEN
    B3: SEA

    C1: New York
    C2: Denver
    C3: Seattle

    How can I make A2 to display "New York-Denver-Seattle ?

    Thank you for helping.
    Reply With QuoteRegister To Reply
  2. 03-23-2017, 08:56 AM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,843

    Re: Iu-line Display of Text in a Cell

    Assuming I understand the availability of this function, this looks like a job for the TEXTJOIN() function: https://support.office.com/en-us/art...3-0e8fc845691c coupled with a lookup function https://support.office.com/en-us/art...8-93a18ad188a1
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to display only the first line of multi-line cell?
    By Dirigo in forum Excel General
    Replies: 4
    Last Post: 05-20-2020, 02:23 PM
  2. [SOLVED] Display a multi-line text box from User Form in a generated outlook e-mail
    By Tnashnhsp1 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-23-2015, 06:11 AM
  3. Display multi line text in sub item of a listview .
    By priya06manohar@gmail in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-18-2014, 02:43 PM
  4. [SOLVED] Display vertical line on stacked line chart already using primary and secondary axises
    By ben_hensel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2012, 10:21 AM
  5. [SOLVED] How to display the arrays with line spcae in between, within a cell?
    By Rahul888 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2012, 11:19 AM
  6. Read the text in a single cell line by line.
    By moon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-14-2010, 06:23 AM
  7. A 2 line text showing up in the Cell in Excel prints in 1 line
    By Cageyslick in forum Excel General
    Replies: 6
    Last Post: 07-12-2005, 04:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1