Excel

Extract characters before first space To extract the string/characters before the first space in an Excal value use the following function: =LEFT("Cell Number", (FIIND(" ", "Cell Number",1)-1)) Alternatively you can also use the following formula to achieve the same result: =LEFT("Cell Number", LEN("Cell Number") - FIND(" ", "Cell Number")) It is important to note in both formulas “Cell Number” is just a placeholder and should be replaced with the actual cell number for the value in which you want to extract (e.