Extract text string into separate cells
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!
Answers
-
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!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives