ST Alpha - "That almost works, except column B is a custom format with leading zeroes. The concatenate makes A001 into A1. -- 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: 159

In response to "=CONCATENATE(A1,B1,"_",C1) -- nm" by JaxSean

That almost works, except column B is a custom format with leading zeroes. The concatenate makes A001 into A1. -- nm

Posted by not2fast Feb 17 '11, 08:06

(No message)

Responses:

=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

Post a message top

Replies are disabled on threads older than 7 days.