In order to create some list, I've been copy some data from the web. Unfortunately it looks like it has been added second row for each record it need.

For example:

sample image

Each record is in the same line, and I'll need to have only the first line of each record (only "Alpena Community College" from the record "Alpena Community College Alpena, MI"

1 Answer 1


Assuming you have a new line character in every cell and you want to extract everything before the new line, try:

=ArrayFormula(iferror(regexextract(A2:A, "^(.+)\n")))

(where A is the column with the addresses and your data starts in row 2 --> change to suit). After that, you can copy the output and use 'paste special' (values only) to overwrite to original column...

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.