most used excel function

Match function - matches two columns

Index - rfers to the values of corresponding cells

convert text to column(delimit) - used to split a text based on space,comma,etc...

MID function

left of

Right of

string length

how to convert text into numbers