Ask Your Question

How to add '' to multiple cells at once? [closed]

asked 2015-08-07 20:10:45 +0100

deredab gravatar image

updated 2020-08-07 23:02:39 +0100

Alex Kemp gravatar image

I have a column of 200+ cells of email accounts that do not have the '' attached on the end. They are all listed in a 'firstname_lastname' fashion, and they are all hosted on the same provider. I would like to simply add '' to all of the cells at once.

  1. Version, English, Calc
  2. Linux Mint 17.2, English
edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2018-10-20 18:38:59.420837

2 Answers

Sort by » oldest newest most voted

answered 2016-05-13 07:02:36 +0100

karolus gravatar image


Select the CellRange in Question and: →Edit→Search and replace

Search for .*
replace with &
with Options:
[x] regular Expression
[x] Selection only

edit flag offensive delete link more

answered 2016-05-13 01:36:37 +0100

IanC1811 gravatar image

Put '' in a cell somewhere ... say cell B2 for example Lets assume your names are in column F beginning at F5 Insert a new column G or use the existing column G if it is empty. At G5 put =CONCATENATE(F5, $B$2) Then just copy this down the column to G205 or whatever the last row of names is. You now have a column of email addresses!

CONCATENATE is the command which joins strings together. Cheers

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2015-08-07 20:10:45 +0100

Seen: 2,417 times

Last updated: May 13 '16