Sunday, November 20, 2016

yogi_modify entries in range A2:A matching those in D1:H1 as specified in the question by the poster

Google Spreadsheet   Post  #2084
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov-20-2016
question by: BillTeach:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/8ogMiVvgF2I;context-place=mydiscussions
Regex formula to replace multiple first words with multiple substitutes
How do I copy from one sheet to another if cell string begins with an apostrophe.

I want to substitute only at the beginning of a string (followed by a space).  For example:
m-> 'm
s -> 's
d -> 'd
ll-> 'll
re -> 're
've -> /ve

or in the complete string:
m going home -> 'm going home

Something like =substitute(A1, "m", char(39)&"m") works for one substitute, but I think regexreplace will be better to replace multiple substrings and only at the beginning of the cell string.