Insert a value to a cell in excel using formula in another cell

0 votes

I need to insert a value to a cell in excel using formula in another cell.

Say

A1 = "Test"
B1 = formula to insert A1 to C1
C1 = A1

Can I write a formula in B1 to insert value in C1? I don't need any formulas in C1. If Yes, What should be the formula?

Mar 24, 2022 in Database by Edureka
• 13,690 points
4,916 views

1 answer to this question.

0 votes

Select the cell where the formula should be entered.

Type = in the Button image formula bar (equal sign).

Choose one of the following options: choose the cell with the desired value or type the cell reference.

A single cell, a range of cells, a place in another worksheet, or a location in another workbook can all be referenced.

When selecting a range of cells, you can relocate the selection by dragging the cell selection's border, or expand the selection by dragging the corner of the border.

Range Finder color-codes precedent cells

answered Mar 25, 2022 by gaurav
• 23,260 points

Related Questions In Database

0 votes
1 answer

Prevent cell numbers from incrementing in a formula in Excel

In Excel, you can use a feature ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
10,773 views
0 votes
1 answer

What is the Excel formula to countif text partially makes up a cell?

With Formulas, Countif Partial String/Substring Match We can ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
16,218 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,370 points
2,324 views
0 votes
2 answers
0 votes
1 answer

Remove special characters from the specified string in excel

To erase a specific character from a ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
1,658 views
0 votes
1 answer

Remove duplicates within a row

To check for duplicates, choose the cells ...READ MORE

answered Mar 15, 2022 in Database by gaurav
• 23,260 points
664 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

Excel formula to remove space between words in a cell

There are three fast techniques to get ...READ MORE

answered Mar 30, 2022 in Database by gaurav
• 23,260 points
797 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP