Reverse Concatenate?
Jeff_Berman
✭✭✭✭
If I have a cell with a string of data such as the following:
CONVMB2021090501
Is it possible to write a formula in another column to extract the date? In this case it would be 09/05/2021
Thanks
Tags:
Best Answer

Not understanding what the difference is.
Answers

Is it always set up this way?
if yes, see below (change the column name to match yours)
=DATE(VALUE(MID(String@row, 8, 4)), VALUE(MID(String@row, 12, 2)), VALUE(MID(String@row, 14, 2)))

@Leibel Shuchat this is great! Thank you! One followup question. One of those sets of data that is being extracted is a date in the format of 20210921. Is there a formula to populate a date (date column type) with the value 9/21/21?

Not understanding what the difference is.

Sorry @Leibel Shuchat  moving too fast
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!