Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
ExtraMediumInc said:
how do i take the combine the text values in columns A and C, remove spaces, and put into column J for all 3000+ rows?
I have a spreadsheet filled with information of over 3000 people. I want to make an extra column (J) that combines the text in columns A and C in each row, removing any spaces, periods, commas, dashes, etc.
--------------------------------------------------------------
In this proposed solution I used RegexReplace function to negate replacement of all AlphaNumeric Characters which of course results in extracting only AlphaNumeric characters
No comments:
Post a Comment