If length of characters in cell is greater than 6, report first 4 characters of the cell....Help pls

[SB1976]

Hi,

Im trying to write a formula in excel;

If length of characters in cell is greater than 6, I'd like to report the first 4 characters of the cell.

Ive been trying combinations like the following but I'm struggling! =IF(LEN(AF15)>6,"left(AF10, 4)","False")

Thank you

 

[63falcondude]

Just remove the quotes around the left statement and make sure that you are referencing the same cell. I noticed you are checking the length of AF15 but then pulling the left 4 characters from cell AF10.

Excel 2010
	A	B
1	String	Result
2	15f78yr	15f7
3	123ab	False
Sheet1

Cell Formulas
Range	Formula
B2	=IF(LEN(A2)>6,LEFT(A2,4),"False")

 

[SB1976]

So close yet so far away...THANK You ...v helpful

 

[63falcondude]

Glad to help. You had the right idea. Just remember to only use the quotes if that is what you want to show. For example (if A1=15f78yr), ="LEFT(A1,4)" will return LEFT(A1,4) while =LEFT(A1,4) will return 15f7.