Forum Discussion
Need help in Excel Formula
Hi, Suppose I have two hundred thousend rows. Each row has car model entries. I would like to write a formula in column B to determine only the model column A belongs to. The formula will just lo...
as I see it, you want column B to get the left string letters only?
if it is separated by a space or comma (delimiter) - it would be quite easy - but
X3xdrive201 BMW - this would be a problem....
if it is separated by a space or comma (delimiter) - it would be quite easy - but
X3xdrive201 BMW - this would be a problem....
Thanks for the reply. No i dont need to extract the left string only. The model name is randomly positioned. It could be in the middle or right. Thats why i need a search function?