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.