
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 16, 2019 11:19 AM
I’m trying to write a formula that would find multiple parts of text (from a single cell) into a short formatted text (in a cell).
Example:
- From “Nothing, we are a turn-key service, from site prep, permits, to completion” to “turn-key”
- From “The client has some responsibility like permits, site-prep, and transportation” to “door-step”
- From “We just send the kit of parts and the client takes care of the majority of work” to “kit-of-parts”
- From “We offer just the drawings / floor plan in addition or exclusively as a service” to “floorplan-only”
I was able to get it to pull just one text but not multiple.
Solved! Go to Solution.
1 Solution
Accepted Solutions

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 07:42 AM
Solution! Use (SUBSTITUTE) formula:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Service Type},"Nothing, we are a turn-key service, from site prep, permits, to completion", "turn-key"), "The client has some responsibility like permits, site-prep, and transportation", "door-step"), "We just send the kit of parts and the client takes care of the majority of work", "kit-of-parts"), "We offer just the drawings / floor plan in addition or exclusively as a service", "floorplan-only")
1 Reply 1

Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 27, 2019 07:42 AM
Solution! Use (SUBSTITUTE) formula:
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE({Service Type},"Nothing, we are a turn-key service, from site prep, permits, to completion", "turn-key"), "The client has some responsibility like permits, site-prep, and transportation", "door-step"), "We just send the kit of parts and the client takes care of the majority of work", "kit-of-parts"), "We offer just the drawings / floor plan in addition or exclusively as a service", "floorplan-only")
