How to combine Left formula with IF isblank

Hi guys,

In the attached spreadsheet, I want to combine the left formula with IF isblank. For example, on column C I want to give me the 3 first characters from the left but keeping in mind that if the cell on column B is empty, then copy results from column A, but only the 3 first characters from the left. Does someone know how to do this please? I will appreciate any help.

Thank you

You can use this formula in cell C2:

=IF(B2="",LEFT(A2,3),LEFT(B2,3))

then copy down.

Hope this helps.

Pete

Thank you Pete!

You're welcome - thanks for the rep.

Pete