Hello I need some help with creating a formula for the below table. What I am trying to achieve is in the "required results" column A. The "Name" entries will always have "Name" preceding
<tbody>
</tbody>
required results | |
Name Jimmy | |
Name Jimmy -shoes | -shoes |
Name Tom | |
Name Tom-Balls | -Balls |
Name Tom-nets | -nets |
Name Tom-snacks | -snacks |
<tbody>
</tbody>