Copy part of a code within a cell
Hello community!
I'm looking for a formula or workaround for capturing part of a code in a cell and copying it from another cell
In my contract number column I have 91B023047
I would like to copy B023 to another cell by somehow removing 91 and 047. Is this possible somehow?
Answers
-
Hi @Sam Swain ,
If the portion of the contract number you want always begins with the 3rd character and you always want 4 characters, this formula will pull that out:
=MID([Column3]@row, 3, 4)
Where [Column3] is your column name.
Hope this helps!
-
Hii Sam Swain,
You can try the below formula for the required condition:
=MID([Contact number]@row, 3, 4)
Thank You!
Anjanesh Vaidya
Thanks,
Anjanesh Vaidya
Smartsheet Development, Ignatiuz Software
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!