Forum Discussion
Find & Select help needed - please see image
Hi, hope everyone is well. I have a spreadsheet that contains Firstname, Lastname, Email Address. I use Find & Select to search for all the @gmail.com But how do I expand to also include Firstnam...
discount85 Hi
See the attached screenshot "1.JPG". Hope it is in the expected format 😉
Formula used in the cell D2 is:
=IF(ISNUMBER(SEARCH("gmail",C2)),CONCAT(A2," ",B2),"")
This will search for the keyword gmail in the email column and if true, will combine the contents of the cell A2 & B2 along with a space in middle.
To copy this in new csv, simply open a new csv and instead of copying the formula, type it and after SEARCH("gmail", switch to old csv (alt+tab) and click on the 1st cell in the column email. Now again alt+tab to go to the new csv and further type two closing brackets. Now, type CONCAT( and alt+tab to old csv and click on A2, the alt+tab to new csv and type ," ",. Now do the same for the rest.
