Friday, September 2, 2011

yogi_Combine Text From Specified Columns And Extract AlphaNumeric Characters Only


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