Extract text string into separate cells

Berto_DA
Berto_DA ✭✭
edited 06/25/24 in Smartsheet Basics

I have predecessors which I converted to text in a separate cell. Below is what it looks like…

If I wanted to extract "181," "182," and "184SF - 20w" into separate cells (three cells in total) how would I do that?

Thank you!

Tags:

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭

    Hi @Berto_D

    How many values do you have in the text cell? Is it just the three as shown in your image? If yes, the formula for your first cell to capture 181 will be =LEFT([name of the column]@row, FIND(",", [name of the column]@row) - 1). The formula for your second cell to capture 182 will be =MID([name of the column]@row, FIND(",", [name of the column]@row) + 1, 4). The formula for the third cell to capture 184SF - 20w will be =MID([name of the column]@row, FIND(",", [name of the column]@row, 9) + 1, 12)

    Thanks,

    Aravind GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • Thank you! That worked!