CALC sheet. First column has hundreds of rows. Each cell contains a number 6 to 16 characters long.
I would like to add a set of characters to the end of each and every set of numbers.
EXAMPLE:
Cell at Col 1, Row 1 is 18757474
Cell at Col 1, Row 2 is 6585859598
I wish to add @jp.gy to the end of each so that they become:
18757474@jp.gy
6585859598@jp.gy
One sheet is 500 rows, but another is over 10,000 rows.
I’m new to spreadsheets, and of course CALC.
Thanks in advance!
.
Hello,
Method 1: Using a helpers column
(assuming Col 1 is column A and Row 1 is 1 - i.e. value 18757474 is in cell A1)
Use the following formula in B1 (or any other column):
=A1 & "@jp.gy" –or–
=CONCAT(A1,"@jp.gy")
and copy that formula down to all rows for which you have data in Col 1.
Method 2: Changing existing values using Find & Replace
Edit -> Find & Replace
(.+)$1@jp.gy[x] Current selection only[x] Regular expressions
Replace All
Hope that helps.
If the answer helped to solve your problem, please click the check mark (
) next to the answer.
That worked perfect. I used your Option 2 because I had data in coloumn 2. Perfect.
Thank You!