I have a column that contains text of varying lengths. I need to create a new column that contains only the text before the first space in the string. So, example in column A I have:
76T VENDOR UNASSIGNED XXXXXX TO LOB
CR18D PEND-REVIEW OF DUPLICATE CODES
I want to add Column B that would be:
76T
CR18D
Thanks