Forum Discussion
Solved
Convert name string to new format
Hello, I am trying to create a function that rearranges how names are automatically produced in Excel. There are instances where there is a middle name letter, full middle name, or no middle ...
=CONCATENATE(MID(A1,SEARCH(", ",A1)+2,SEARCH(" ",A1,SEARCH(", ",A1)+2)-SEARCH(", ",A1)-2)," ",LEFT(A1,SEARCH(", ",A1)-1))
You can try this formula.
=CONCATENATE(MID(A1,SEARCH(", ",A1)+2,SEARCH(" ",A1,SEARCH(", ",A1)+2)-SEARCH(", ",A1)-2)," ",LEFT(A1,SEARCH(", ",A1)-1))
You can try this formula.
You are an absolute legend, thank you