Extract text string into separate cells

Berto_DA

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!

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)

Berto_DA

Thank you! That worked!