Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.

Get a Professional Answer

Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.

100% Satisfaction Guarantee

Rate the answer you receive.

Ask Steve Your Own Question

Steve, Consultant

Category: Programming

Satisfied Customers: 275

Experience: Steve is a consultant in the areas of computer software and programming, information management and networking.

47680681

Type Your Programming Question Here...

Steve is online now

You just sent me an answer to question Order ID:

Customer Question

Steve you just sent me an answer to question Order ID: 16330370-853 This is not what I am looking for I have a column that represents the entry data number for a row of imputed data. say #1 the #2 #3 all the way to number 4000 in my column. This raw data and I am trying to upload it to a website so it can recognize it correctly. So first column 1 row # ***** / 2nd column 1 row 500-1 / 3 column 1 row 500-3 So I have a number in the row 1st column is my entry I need to take that number and add in

OK, so it's the answer I put on the other question. If the number is ***** column B, the the formula for C2 is =CONCATENATE(B2,"-1") and the formula for D2 is =CONCATENATE(B2, "-3"). And then you copy the formula down.

You probably started in the wrong cell. if the formula says "B2", you have to put the formula on Row 2 for C and D. When you copy it down, Excel automatically increases the row number for you. But if you don't start in the right place, your numbering will be off.

Hi there, sorry I wasn't available on Friday. I attached the document here with the formulas in columns C and D. Chat me back if you want to discuss this further. Hope you had a good holiday weekend!