Function Reconfig(S As String)
Dim V As Variant, i As Long
V = Split(S, " ")
For i = 1 To UBound(V) + 1
Reconfig = Reconfig & i & "• " & V(i - 1) & " "
Next i
End Function
Hi,
If you're nesting formulas, you need to remove the =
so your formula =(A1) nested with the iferror function becomes =IFERROR(A1,"")
Hi jorismoerings, the OP isn't in reality using the formula =A1, they are using the UDF Reconfig (see post #15 but the UDF should actually look like the UDF below (at least it should if it doesn't turn out to be better to change the UDF when the OP actually states what causes the error/s))
Code:Function Reconfig(S As String) Dim V As Variant, i As Long V = Split(S, " ") For i = 1 To UBound(V) + 1 Reconfig = Reconfig & i & "• " & V(i - 1) & " " Next i End Function