CODEWITHSUNDEEP
excel-formula
aviaPL
aviaPL

Reputation: 99

How to get string after first space in Excel

I have MS Excel file with 8k products code. For example:

SOR 309704 or
LEW 2992 6005BK

I need a formula which cut this string to first space.

SOR 309704 to 309704
LEW 2992 6005BK to 2992 6005BK

Can You help me with this problem ?

Kind regards

Upvotes: 4

Views: 31167

Answers (1)

citivin
citivin

Reputation: 686

=FIND(" ",A1) will give you the position of the first space character. Then you can take everything on the right-hand side using the right() function:

=RIGHT(A1, LEN(A1) - FIND(" ", A1))

Upvotes: 11

Related Questions