extract number sequence in excel

I have data in the form:

1963 V5A1T 1001 6960
1964 V5A1T 6961 61346
1965 V5A1T 61347 92876

I would like to extract the number sequence after the second and third spaces and store in a separate column.

not sure how
PeterBaileyUkAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
Why not highlight the data, and select Data - Text to Columns - select Delimited - and select "Space" and Finish.
0
 
Shaun KlineLead Software EngineerCommented:
You can use:
=SEARCH(CHAR(127),SUBSTITUTE(A2," ",CHAR(127),<n>))

Open in new window

to find the nth occurrence of a space. Using this with the MID formula:
MID(A2, SEARCH(CHAR(127),SUBSTITUTE(A2," ",CHAR(127),2)), SEARCH(CHAR(127),SUBSTITUTE(A2," ",CHAR(127),3)) - SEARCH(CHAR(127),SUBSTITUTE(A2," ",CHAR(127),2)))

Open in new window


This formula will pull out the text between the 2nd and 3rd space if your text is in A2.
0
 
PeterBaileyUkAuthor Commented:
Thank you worked a treat very quick and simple
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.