April 16, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Find a cell with the same 3 first characters and return the row number

Lets say I have a list of codes in a column, I want to find the row number of the code that star with ALB, for example.

I tried to use MATCH and LEFT but im not sure how to make the fuction MATCH just check the first few characters, instead of the exact value.

Check out the full article on the original site

#Excel alternatives for data analysis

#row zero

#rows.com

#financial modeling with spreadsheets

#natural language processing for spreadsheets

#generative AI for data analysis

#Excel compatibility

#no-code spreadsheet solutions

#Excel alternatives

#row number

#MATCH

#cell

#first characters

#LEFT

#codes

#find

#column

#function

#check

#exact value

Find a cell with the same 3 first characters and return the row number