Hi,
In the attached workbook, i need to pull out the first word of the string and populate column C with it but i need a formula to do this?
Any ideas, the only thing i can think of is using the Left function but that won't work as the word length is different for each line...
Bookmarks