looks like 1280 the zone has an excel whiz on their hands.

Report problem with this ad

Jul 30, 2014
1:01:31pm

BYUheaven

looks like 1280 the zone has an excel whiz on their hands.

Report problem with this ad

BYUheaven

Bio page: BYUheaven
Joined: Jan 5, 2011
Last login: Jun 13, 2024
Total posts: 38,533 (5,059 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?

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.

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