My Account
Sign up, and you can make all message times appear in your timezone.
Sign up
Report problem with this ad
Start a related thread
Start a related poll
Reply via Boardmail
Jul 30, 2014
12:51
:58
pm
ColoSpgs
Cumbersome way: Use the Left and Right commands
=Left(A1,1) will give you the leftmost number or character in cell A1.
=Left(Right(A1,2),1) will give you the second character from the right in cell A1.
There's probably an easier way, too.
Start a related thread
Start a related poll
Reply via Boardmail
Report problem with this ad
ColoSpgs
New username
Underhill
Bio page
ColoSpgs
Joined
Sep 13, 2002
Last login
Mar 25, 2024
Total posts
0 (0 FO)
Report problem with this ad
Messages
Author
Time
Excel Question
BYUheaven
7/30/14 12:43pm
Cumbersome way: Use the Left and Right commands
ColoSpgs
7/30/14 12:51pm
Will they always be single digits or will it vary?
Hoosier Cougar
7/30/14 12:52pm
^^ Must know this before you use my suggestion
ColoSpgs
7/30/14 12:54pm
10 is the max
BYUheaven
7/30/14 12:54pm
So it'll vary. That'll complicate it a little.
Hoosier Cougar
7/30/14 12:55pm
Not an Excel person, but I would start by Googling "excel regex"
BertoChavez
7/30/14 12:54pm
Looks like you can definitely *match* patterns with regex or similar, but I'm
BertoChavez
7/30/14 12:57pm
RE: Excel Question
caillou
7/30/14 12:58pm
looks like 1280 the zone has an excel whiz on their hands.
BYUheaven
7/30/14 1:01pm
thank you
BYUheaven
7/30/14 1:02pm
^^^^ Does budgeting for 1280.
BYUinTX
7/30/14 1:01pm
It's likely to get a bit messy if you're trying to do too much in a single cell
JadoX
7/30/14 1:01pm
Report problem with this ad
Posting on CougarBoard
In order to post, you will need to either
sign up
or
log in
.
Report problem with this ad