tblackwell
New Member
- Joined
- Oct 24, 2018
- Messages
- 28
- Office Version
- 365
- Platform
- Windows
Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me.
Question: If cell's contains this do this until...
Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first four characters of that cell.
I got that but here is where I get stuck: If does not begin with 6, then use first four characters of cell that does begin with 6 UNTIL it finds a new number
Current formula where I get stuck: =IF(LEFT(C14,1)="6",LEFT(C14,4),C13)
System: Windows 10 Pro
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
<tbody>
</tbody>
Question: If cell's contains this do this until...
Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first four characters of that cell.
I got that but here is where I get stuck: If does not begin with 6, then use first four characters of cell that does begin with 6 UNTIL it finds a new number
Current formula where I get stuck: =IF(LEFT(C14,1)="6",LEFT(C14,4),C13)
System: Windows 10 Pro
C | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13 | Reference Cells | My Formula | What I Want | ||||||||||
14 | 6001 24 Highway - 2192 | 6001 | 6001 | ||||||||||
15 | L-FREE-CHIKNWFRYDRNK | 6001 24 Highway - 2192 | 6001 | ||||||||||
16 | L-FREE-SINGLE FRYDRK | L-FREE-CHIKNWFRYDRNK | 6001 | ||||||||||
17 | N-0200-OFF FULLSALAD | L-FREE-SINGLE FRYDRK | 6001 | ||||||||||
18 | N-0200-OFFCOMBO | N-0200-OFF FULLSALAD | 6001 | ||||||||||
19 | N-BOGO-3PC TENDERS | N-0200-OFFCOMBO | 6001 | ||||||||||
20 | N-BOGO-CHICKEN | N-BOGO-3PC TENDERS | 6001 | ||||||||||
21 | N-BOGO-SINGLECHEESE | N-BOGO-CHICKEN | 6001 | ||||||||||
22 | N-DISC-2SGLCHZ CMB | N-BOGO-SINGLECHEESE | 6001 | ||||||||||
23 | N-DISC-2SPC CHK CMB | N-DISC-2SGLCHZ CMB | 6001 | ||||||||||
24 | N-DISC-DBL CHZ CMB | N-DISC-2SPC CHK CMB | 6001 | ||||||||||
25 | N-DISC-KM CHICKEN | N-DISC-DBL CHZ CMB | 6001 | ||||||||||
26 | N-DISC-KM CHK TENDER | N-DISC-KM CHICKEN | 6001 | ||||||||||
27 | N-DISC-KM CHZBURGER | N-DISC-KM CHK TENDER | 6001 | ||||||||||
28 | N-DISC-KM HAMBURGER | N-DISC-KM CHZBURGER | 6001 | ||||||||||
29 | N-DISC-KM NUGGET | N-DISC-KM HAMBURGER | 6001 | ||||||||||
30 | N-DISC-KM WRAPS | N-DISC-KM NUGGET | 6001 | ||||||||||
31 | N-FREE-COOKIE | N-DISC-KM WRAPS | 6001 | ||||||||||
32 | N-FREE-JRFRSTYKEYTAG | N-FREE-COOKIE | 6001 | ||||||||||
33 | N-FREE-TNDRSW/FRYDRK | N-FREE-JRFRSTYKEYTAG | 6001 | ||||||||||
34 | 6001 24 Highway - 2192 Quantity: | 6001 | 6001 | ||||||||||
35 | 6002 40 Highway - 8246 | 6002 | 6002 | ||||||||||
36 | L-FREE-CHIKNWFRYDRNK | 6002 40 Highway - 8246 | 6002 | ||||||||||
37 | L-FREE-SINGLE FRYDRK | L-FREE-CHIKNWFRYDRNK | 6002 | ||||||||||
38 | N-0200-OFF FULLSALAD | L-FREE-SINGLE FRYDRK | 6002 | ||||||||||
39 | N-0200-OFFCOMBO | N-0200-OFF FULLSALAD | 6002 | ||||||||||
40 | N-BOGO-3PC TENDERS | N-0200-OFFCOMBO | 6002 | ||||||||||
41 | N-BOGO-CHICKEN | N-BOGO-3PC TENDERS | 6002 | ||||||||||
42 | N-BOGO-SINGLECHEESE | N-BOGO-CHICKEN | 6002 | ||||||||||
43 | N-DISC-2SGLCHZ CMB | N-BOGO-SINGLECHEESE | 6002 | ||||||||||
44 | N-DISC-2SPC CHK CMB | N-DISC-2SGLCHZ CMB | 6002 | ||||||||||
45 | N-DISC-DBL CHZ CMB | N-DISC-2SPC CHK CMB | 6002 | ||||||||||
46 | N-DISC-KM CHICKEN | N-DISC-DBL CHZ CMB | 6002 | ||||||||||
47 | N-DISC-KM CHK TENDER | N-DISC-KM CHICKEN | 6002 | ||||||||||
48 | N-DISC-KM CHZBURGER | N-DISC-KM CHK TENDER | 6002 | ||||||||||
49 | N-DISC-KM HAMBURGER | N-DISC-KM CHZBURGER | 6002 | ||||||||||
50 | N-DISC-KM NUGGET | N-DISC-KM HAMBURGER | 6002 | ||||||||||
51 | N-DISC-KM WRAPS | N-DISC-KM NUGGET | 6002 | ||||||||||
52 | N-FREE-COOKIE | N-DISC-KM WRAPS | 6002 | ||||||||||
53 | N-FREE-JRFRSTYKEYTAG | N-FREE-COOKIE | 6002 | ||||||||||
54 | N-FREE-TNDRSW/FRYDRK | N-FREE-JRFRSTYKEYTAG | 6002 | ||||||||||
55 | 6002 40 Highway - 8246 Quantity: | 6002 | 6002 | ||||||||||
56 | 6003 State Ave - 2183 | 6003 | 6003 | ||||||||||
57 | L-FREE-CHIKNWFRYDRNK | 6003 State Ave - 2183 | 6003 | ||||||||||
58 | L-FREE-SINGLE FRYDRK | L-FREE-CHIKNWFRYDRNK | 6003 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
ToFormat
Worksheet Formulas
<thead> </thead><tbody> </tbody> |
<tbody>
</tbody>