0

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

0

1 Answer 1

2

Use LEFT and FIND:

=LEFT(A1,FIND(" ",A1 & " ")-1)

As @Jeeped pointed out the & " " will avoid an error if no space is found and return the whole string.

0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .