Consulting

Results 1 to 2 of 2

Thread: How to conjuct all the excel value into one cell?

  1. #1
    VBAX Contributor
    Joined
    Nov 2009
    Posts
    114
    Location

    How to conjuct all the excel value into one cell?

    Dear all,

    cell A1 = 9-19
    cell B1 = 10-19
    .
    .
    .
    .
    cell Z1 = 5-21


    cell AA1 = 9-19 10-19 . . . . . 5-21

    What is the formula can conjuct all the txt into one cell?

  2. #2
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,064
    Location
    Have a look at the concatenate function.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •