ST Alpha - "Need some Excel help. I need to concatenate strings like this:" (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: 159

Need some Excel help. I need to concatenate strings like this:

Posted by not2fast Feb 17 '11, 07:58

I have 3 columns, A, B and C. I want the value in column D to be AB_C, with no spaces between them. What formula would I use?

Responses:

=CONCATENATE(A1,B1,"_",C1) -- nm - JaxSean Feb 17, 08:02 6
- Concatenation is probably illegal in a number of states. -- nm - Max Feb 17, 08:16
- That almost works, except column B is a custom format with leading zeroes. The concatenate makes A001 into A1. -- nm - not2fast Feb 17, 08:06 3
  - =CONCATENATE(A2,TEXT(B2,"000"),"_",D2) - JaxSean Feb 17, 08:16 1
    - Yep, that worked. Thanks. -- nm - not2fast Feb 17, 08:17
  - did you try inserting a new column with 00 in it? (non-numeric, obviously) -- nm - loosilu Feb 17, 08:14
- this. -- nm - loosilu Feb 17, 08:02

Post a message top

Replies are disabled on threads older than 7 days.