ST Alpha - "This is probably Excel 101, but... whats the function to string all cell data in cols A,B,C on one spreadsheet tab into col A on my second tab? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 158

This is probably Excel 101, but... whats the function to string all cell data in cols A,B,C on one spreadsheet tab into col A on my second tab? -- nm

Posted by Max Aug 6 '16, 17:29

(No message)

Responses:

you could do =CONCATENATE(Sheet1!A1,Sheet1!B1,Sheet1!C1) -- nm - prayformojo Aug 6, 17:52 4
- I think that combines multicells into one cell right? I described it incorrectly. - Max Aug 6, 18:38 3
  - Copy -> Paste Special -> Transpose -- nm - iSpam Aug 6, 18:43 2
    - You'll have to do it row by row -- nm - iSpam Aug 6, 18:48 1
      - Okay, just wanted to make sure I wasn't missing a simpler solution. -- nm - Max Aug 6, 18:49

Post a message top

Replies are disabled on threads older than 7 days.