1.

Solve : excel function question =Left (X?

Answer»

I'm TRYING to remember how the format of this function is setup: "=left (cell,x,x) " or "=right(x,x,x)
Any help would be great, and thank you!
The function will COPY the requested # of characters from the specified side, left or right, from an adjacent cell and display them in the formulation cell
The help resources provided within Excel tend to be quite useful. Look up the function in help.I have not found the proper terminology to locate the function in helpThe proper terminology is simply right function or left function.  Have you tried using the function button on the menu to find these two functions?  They categorized as Text functions.I just TYPE "LEFT" in the help field and I got the result....anyway, here's a brief description of the function copied from the Help.


Syntax

LEFT(text,num_chars)

LEFTB(text,num_bytes)

Text   is the text STRING that contains the characters you want to extract.

Num_chars   specifies the number of characters you want LEFT to extract.

Num_chars must be greater than or equal to zero.

If num_chars is greater than the length of text, LEFT returns all of text.

If num_chars is omitted, it is assumed to be 1.

Num_bytes   specifies the number of characters you want LEFTB to extract, BASED on bytes.



Discussion

No Comment Found