can anyone help me regarding the question, i am not able to get the proper answer. using vlookup i have extract the whole
name from the provided raw data now i want to get the first name only
like newyork,ny-incorrect
newyork-correct