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
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives