Extract text string into separate cells

Options
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 ✭✭✭✭✭✭
    Options

    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

  • Berto_DA
    Options

    Thank you! That worked!