Sub config_change_input_substitute()


'----------------------

row_start = 3
row_end = 130

col_inputstart = 3

col_output = 10



'----------------------
Dim arr2_conf As Variant
Dim arr2_conf_sub As Variant

For i = row_start To row_end
  
   str2 = Cells(i, 2).Value
   
   arr2_conf = Split(str2, " ")
   len_arr2_conf = UBound(arr2_conf)
   
   arr2_conf_sub = Split(str2, " ")
   len_arr2_conf_sub = UBound(arr2_conf_sub)
  
  
   countperline = 0
   For j = 0 To len_arr2_conf

    If arr2_conf_sub(j) Like "*★*" Then

     arr2_conf_sub(j) = Cells(i, col_inputstart + countperline).Value
     countperline = countperline + 1
    End If
    
    If maxcount < countperline Then
      maxcount = countperline
    End If
   Next j

   For k = 0 To len_arr2_conf_sub
    str_sub = str_sub & " " & arr2_conf_sub(k) & " "

   Next k

   Cells(i, col_output).Value = str_sub
   str_sub = ""
   
Next i

End Sub










Sub config_change_input_format()



'----------------------

row_start = 3
row_end = 130


col_inputstart = 3

col_output = 10



'----------------------

Dim arr_conf As Variant
Dim str1  As String

Count = 1

For i = row_start To row_end
  
   str1 = Cells(i, 1).Value
   

   arr_conf = Split(str1, " ")
   len_arr_conf = UBound(arr_conf)
       
   countperline = 0
   For j = 0 To len_arr_conf

    If arr_conf(j) Like "*★*" Then
     arr_conf(j) = "★" & Count & "★"
     Cells(i, col_inputstart + countperline).Interior.ColorIndex = 4
     countperline = countperline + 1
     Count = Count + 1
    End If

    If maxcount < countperline Then
      maxcount = countperline
    End If
   Next j

   For k = 0 To len_arr_conf
    str2 = str2 & " " & arr_conf(k) & " "
   Next k

   Cells(i, 2).Value = str2
   str2 = ""
   
Next i



End Sub