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 clien...
I’m trying to write a formula that would format a long text to a short formatted text. Example: “We offer just the drawings and floor plan in addition or exclusively as a service” to “floorplan-only”
The tricky part is there are 4 different types:
Se...
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...
