How to remove a zero after the first 2 letters in a string of text?
I have data that varies where the zero is located. Some examples would be AA01 or AA01x as well as AA12, etc.
The first two characters are always letters and I want to return the rest of string without any zeros.
I need to just remove the Zero where ever it may be in that string. Typically, but not always the Zero is at the third digit. The outcome should look like this: AA1 or AA1x or AA12
Thanks in advance!
Best Answers

Hi Scott, to remove all zeros you can use a formula like this:
=SUBSTITUTE([Column]@row, "0", "")
Hope that works? :)

You are a ROCKSTAR!! Works perfectly and very simple.
=SUBSTITUTE([Column]@row, "0", "")
Thanks again!!
Answers

Hi Scott, to remove all zeros you can use a formula like this:
=SUBSTITUTE([Column]@row, "0", "")
Hope that works? :)

You are a ROCKSTAR!! Works perfectly and very simple.
=SUBSTITUTE([Column]@row, "0", "")
Thanks again!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!