Horje
extract the nth word from a text string Code Example
extract the nth word from a text string 
Excel formular
=TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",LEN(A1))), (N-1)*LEN(A1)+1, LEN(A1)))
'Replace A1 with the target columns
'Replace N with the word position
Source: exceljet.net



Vb

Related
excel vba how to reset usedrange Code Example excel vba how to reset usedrange Code Example
vba file from path Code Example vba file from path Code Example
excel vba determine number of elements in a 2D array Code Example excel vba determine number of elements in a 2D array Code Example
excel vba recursive example factorial function Code Example excel vba recursive example factorial function Code Example
excel vba extract file name Code Example excel vba extract file name Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 9



 

Horje