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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!