Help

Formula for finding multiple text and translating it to another cell

Topic Labels: Formulas
Solved
Jump to Solution
2530 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")