LEFT function - Get Digital Help

Get Digital Help

<a href="//pixfuture-d.openx.net/w/1.0/rc?cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" ><img src="//pixfuture-d.openx.net/w/1.0/ai?auid=538803744&cs=5e204d84f8&cb=INSERT_RANDOM_NUMBER_HERE" border="0" alt=""></a>

LEFT function

Excel » Functions » Text » LEFT function »

Extract first word in cell

The formula in cell C3 grabs the first word in B3 using a blank as the delimiting character. =LEFT(B3,SEARCH(" ",B3)-1) […]

LEFT function for numbers

The LEFT function allows you to extract a string from a cell with a specific number of characters, however, if […]

How to use the LEFT function

The LEFT function extracts a specific number of characters always starting from the left. Excel Function Syntax LEFT(text, [num_chars]) Arguments […]

Sum values containing text based on a condition

Question: I want to sum cells that have a "C" and a decimal number. The cells have other numbers and […]

Cells with text values

Cells with empty values

String in cell range

Strings in cell range

String in rng, case sens.

Cells equal list values

Containing any list value

Rows containing data

Pattern in cell value

Days between dates

Weeks between dates

Months between dates

Years between dates

Workdays betw. 2 dates

Specific wkdays in rng

Sum nums betw. dates

Overlapping ranges

Latest date - condition

Match date in date rng

Create date range

Hours between times

How to AVERAGE time

Overlapping ranges

First word in cell value

K-th word in cell value

Last word in cell value

First three digits in value

Numbers in cell value

Text string manipulation

Replace part of formula

Critera - multiple results

Multiple results

Multiple conditions

Get the latest revision

Last value in column

Last value unsorted list

Extract using criteria(3)

Lookup - two conditions

Two-dimensional lookup

Find closest value

If cell has value

If cell contains any text

Cell contains list value

Cells equal to list value

Cell contains list value

If cell contains text

Multiple conditions

IF & AND - Conditions

Nested IF functions

Sum nums betw. dates

Advanced totals

Sum based on criteria

Running totals - date

Average function

Average - criteria

AVERAGE ignore NA()

How to AVERAGE time

Average - no blanks

Average function

Running average

Average ignore 0

Sumproduct function

Nested IF functions

SUMPRODUCT - blank

SUMPRODUCT & IF

Multiple conditions

SUMPRODUCT - count

Match nos & letters

Critera - multiple results

Small - Index Match

Multiple results

Match two columns

Multiple conditions

Extract headers

Two-dimensional lookup

SMALL - multiple rngs

Small - Index Match

SMALL - ignore 0

SMALL with conditions

SMALL function for text

SMALL with dupes

Multiple results

How to use the MIN function

Lookup using two criteria

How to quickly find the maximum or minimum value [Formula]

From a cell range

Find closest value

How to use the MAX function

Fuzzy vlookup [Array formula]

Extract unique distinct values sorted based on sum of adjacent values

How to quickly find the maximum or minimum value [Formula]

Rearrange cells in a cell range to vertically distributed values

Numbers in cell value

How to remove unwanted characters in a cell

Identify all characters in a cell value

How to remove numbers from a cell value

Critera - multiple results

Small - Index Match

Multiple results

Multiple conditions

Rearrange values

Find numbers closest to sum

How to use the INDEX function

Year - month from dates

Two-dimensional lookup

From a cell range

Containing any list value

Sum nums betw. dates

How to use the SUM function

Count overlap. days(1)

Strings in cell range

Count overlapping dates

Sum based on multiple criteria

Sum values between two dates and based on a condition

Sum values containing text based on a condition

String in rng, case sens.

Unique dist. values

String in cell range

Sum cells with check boxes

Sum only visible cells

Formula categories

Index and Match

String manipulation