Hi Guys Good Morning from Sri Lanka,

I want a favor with regards to getting a Cell formatted to a standard Cell.

What I have:

A1=Green Hoodie: 5
A2=Green Hoodie: 10 Black Hoodie: -
A3=White Hoodie: 4

What I Need:

B1=Green Hoodie: 5 Black Hoodie: N/A White Hoodie: N/A
B2=Green Hoodie: 10 Black Hoodie: N/A White Hoodie: N/A
B3=Green Hoodie: N/A Black Hoodie: N/A White Hoodie: 4

At times we get the Number along with the words like Pieces, or pcs...but that's completely Fine. Therefore when you make the UDF/formuala please regard the number string which appear here irrelevant as a Text or Numeric

ex:
A1=Green Hoodie: 5pcs
A1=Green Hoodie: 5Nos

Thank you...