ExcelBanter - How do I write "begins with"?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I write "begins with"? (https://www.excelbanter.com/excel-discussion-misc-queries/131840-how-do-i-write-begins.html)

Terri

How do I write "begins with"?

I want my formula to say =if(B3 "begins with" Computer, B3, 0). So, I want
the formula to go to cell B3, if it begins with the word computer, (could be
computer desk, or computer monitor) then put it in the cell that I am in, if
not, put 0.
--
Terri
Amos Pewter

Mike

How do I write "begins with"?

=IF(LEFT(B3,8)="Computer",B3,0)

"Terri" wrote:

I want my formula to say =if(B3 "begins with" Computer, B3, 0). So, I want
the formula to go to cell B3, if it begins with the word computer, (could be
computer desk, or computer monitor) then put it in the cell that I am in, if
not, put 0.
--
Terri
Amos Pewter

All times are GMT +1. The time now is 12:38 PM.