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 1, 17:33
2: Dec 1, 11:23
3: Nov 30, 15:54
4: Nov 30, 09:41
5: Nov 29, 16:44
6: Nov 29, 08:01
7: Nov 28, 16:19
8: Nov 28, 09:42
9: Nov 27, 18:07
10: Nov 27, 12:04
11: Nov 27, 08:26
12: Nov 26, 18:06
13: Nov 26, 12:05
14: Nov 26, 08:29
15: Nov 25, 18:33
16: Nov 25, 11:12
17: Nov 25, 07:08
18: Nov 24, 13:17
19: Nov 23, 18:13
20: Nov 23, 06:17
Posts: 154
In response to
"
yes. -- nm
"
by
b.
Actually, I just figured a way, where it doesn't matter.
Posted by
musubi
Aug 5 '09, 10:43
If the address is in A1, in B1, use:
=FIND(@,A1)-1
Then in C1, use:
=Left(A1,B1-1)
That should work.
Responses:
You could combine the formulas into one cell. Of course, Enders Data to text is probably simpler. (nm)
-
musubi
Aug 5, 10:46
Post a message
top
Replies are disabled on threads older than 7 days.