Sunday, June 4, 2017

yogi_Remove 'as of date and space character' from entries in column A In-Situ

Google Spreadsheet   Post  #2174
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-04-2017
question by Kathy VanDeven:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/ATVtdBVqt_A;context-place=mydiscussions
How do I replace text and date with nothing?
as of 02/28/2017 PIMCO INCOME FUND CL D
as of 02/28/2017 PIMCO INCOME FUND CL D
as of 03/28/2017 VANGUARD WELLINGTON INVESTOR
as of 03/28/2017 VANGUARD WELLINGTON INVESTOR
as of 03/28/2017 VANGUARD/WELLESLEY INCOME INVESTOR
as of 03/31/2017 HENNESSY GAS UTILITY INVESTOR CL

want to replace as of and whatever date that follows it.  I am using a Chromebook.