-
Get a Cell into a Standard Format depending on its Contents - UDF/Formula Only
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...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules