Google-sheets – Function/formula to return only the first string proceeding the first carriage return

formulasgoogle sheets

Is there a function/formula to return only the first string proceeding the first carriage return using Google Sheets?

Example Text:

Bob & Mary Smith   
bob@email.com   
555-111-1234

Assuming the above text is in cell A1, I would like the formula to return the following to Cell B1 "Bob & Mary Smith"

Generally speaking, this would do it:

=REGEXEXTRACT(A1,"(.+)\n")

You can check whether a cell is empty or not by using the following formula:

=if(C2="";"The cell is empty";"The cell is not empty")

=SUMIF(D:D,"bob",C:C)

in C column are numbers, in D column are ("bob" or others)

if you wish do not sum all column you can use for example

=SUMIF(D2:D6,"bob",C2:C6)

Note: Text is case sensitive (Bob is not equal bob)