Ask Your Question
0

How to add '@example.com' to multiple cells at once? [closed]

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

deredab gravatar image

updated 2015-08-24 05:50:32 +0200

Alex Kemp gravatar image

I have a column of 200+ cells of email accounts that do not have the '@example.com' 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 '@example.com' to all of the cells at once.

  1. Version 4.4.3.2, 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
1

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

karolus gravatar image

Hallo

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

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

edit flag offensive delete link more
0

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

IanC1811 gravatar image

Put '@example.com' 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

Stats

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

Seen: 1,054 times

Last updated: May 13 '16