Extracting Numbers from a Cell Containing Both Text & Numbers

Options
Allison_S
Allison_S ✭✭✭
edited 12/09/19 in Formulas and Functions

Hi All -

I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will not convert the cell contents into scientific notation). I need to remove the '$ text from the cell, so I can sum the value of the column in a separate reporting sheet. I was hoping to add a neighboring column to the Smartsheet sheet (that I am uploading the .csv file to) that would automatically extract only the number value of the neighboring cell, so I can link that column to my reporting sheet and obtain the numeric sum of each cell. Hopefully this makes sense, any formula suggestions? Appreciate any help I can get! 

 

Thank you! 

Allison

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!