View attachment 49276
- Load from table
- define as text data type
- split by number of characters (PQ to my knowledge does not see colour), like Hui suggested via formula.View attachment 49275
- transforms to this...
Could it be that you need to use ";" between the arguments of the function instead of ","?Hi @Hui ,
Thanks for help, but your formula doesn't work.
or you get wrong that meaning?
i need to split that red colour number...
Function Get_Red(ByRef target As Variant) As String
'Get Red part of string
Dim i As Integer
For i = 1 To Len(target)
If target.Characters(Start:=i, Length:=1).Font.Color = 255 Then
Get_Red = Right(target, Len(target) - i + 1)
Exit Function
End If
Next
End Function
Could it be that you need to use ";" between the arguments of the function instead of ","?