Log In
Create Account
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
Links Only
50 Results
100 Results
250 Results
500 Results
1000 Results
5000 Results
2 Weeks
2 Months
6 Months
1 Year
2 Years
5 Years
All Time
Live
Down to Post
Backboards:
Live
________________
1: Dec 3, 14:19
2: Dec 3, 11:17
3: Dec 3, 07:33
4: Dec 2, 17:22
5: Dec 2, 11:48
6: Dec 2, 08:21
7: Dec 1, 17:33
8: Dec 1, 11:23
9: Nov 30, 15:54
10: Nov 30, 09:41
11: Nov 29, 16:44
12: Nov 29, 08:01
13: Nov 28, 16:19
14: Nov 28, 09:42
15: Nov 27, 18:07
16: Nov 27, 12:04
17: Nov 27, 08:26
18: Nov 26, 18:06
19: Nov 26, 12:05
20: Nov 26, 08:29
Posts: 159
In response to
"
That almost works, except column B is a custom format with leading zeroes. The concatenate makes A001 into A1. -- nm
"
by
not2fast
=CONCATENATE(A2,TEXT(B2,"000"),"_",D2)
Posted by
JaxSean (aka JaxSean)
Feb 17 '11, 08:16
the number of zeroes in that text function should match whatever your custom format is.
Responses:
Yep, that worked. Thanks. -- nm
-
not2fast
Feb 17, 08:17
Post a message
top
Replies are disabled on threads older than 7 days.