Hi all,
Thank you in advance for your help.
In cell A2 I have: Field3,Field8,Field9,Field10
In cell B2 I would like to get: 2 (the position of the 2 word Field8 in string)
I tried using InStr in UDF
In cell B2 I am using below function: FindWordPosition(A2,"Field8")
result of function in...
Hi all,
Thank you in advance for your help. I am working on a function in cell B to find and replace text in cell A. I still need cell A is a field I and cell B is a classification of that ID. The UDF I have only replace 1 (the last string in example below Date) of the three strings I want...
Hi all,
Struggling to find solution for this one. I need to loop through rows in column A and populate columns B1:Nth1 with text = field & # from row. Then populate values in column B2:Nth# from values in based on values in sting in column A. See attached example. Items in yellow are derived...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.