How to add a number in front of a number sequence in bulk

rebel123

Active Member
Joined
Apr 18, 2017
Messages
348
Office Version
  1. 365
Platform
  1. MacOS
I have the following rows. I use Google Sheets so I need the = formula

County is ROW L1
Parcel is ROW M1
NEW PARCEL is ROW N1

How do I fill in the blanks and I want the parcels to have an R in front of them.

So, BLANK 1 is row N2 and the end result should be an equation in which the answer is R020101100000003
So, BLANK 2 is row N3 and the end result should be an equation in which the answer is R020104410004017005
So, BLANK 3 is row N4 and the end result should be an equation in which the answer is R020104410004033


CountyParcelNew Parcel
Mobile020101100000003(BLANK 1)
Mobile020104410004017005(BLANK 2)
Mobile020104410004033(BLANK 3)
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Do you need something like this?

Book1
LM
1
22011103R02011103
Sheet1
Cell Formulas
RangeFormula
M2M2="R"&L2
 
Last edited by a moderator:
Upvote 0
It is correct, the formula goes in cell N2.
I'm glad to help you. Thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,223,155
Messages
6,170,405
Members
452,325
Latest member
BlahQz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top