Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula for finding multiple text and translating it to another cell

Topic Labels: Formulas
Solved
Jump to Solution
2844 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Caleb_Barclay
4 - Data Explorer
4 - Data Explorer

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:

  1. From “Nothing, we are a turn-key service, from site prep, permits, to completion” to “turn-key”
  2. From “The client has some responsibility like permits, site-prep, and transportation” to “door-step”
  3. From “We just send the kit of parts and the client takes care of the majority of work” to “kit-of-parts”
  4. 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.

Screen Shot 2019-12-09 at 9.37.35 PM

1 Solution

Accepted Solutions
Caleb_Barclay
4 - Data Explorer
4 - Data Explorer

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")

See Solution in Thread

1 Reply 1
Caleb_Barclay
4 - Data Explorer
4 - Data Explorer

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")