Setting an Excel Worksheet Cell to a String

Sets the value of a cell in a worksheet to a specified string.

This reference documentation is for the Legacy Microsoft Excel book. Refer to the latest version here.

Syntax

set the cell to "{new value}"

Inputs

1. new value: The new text value to set the cell to.

Example

Given the following table and cell C3:

	A	B	C
1	Plant Type	Environment	Companion
2	Fern	Shade	Moss
3	Cactus	Desert	Succulent
4	Bamboo	Tropical	Ivy

set the cell to "Agave"

This operation will replace Succulent with Agave in cell C3. The new table would be:

	A	B	C
1	Plant Type	Environment	Companion
2	Fern	Shade	Moss
3	Cactus	Desert	Agave
4	Bamboo	Tropical	Ivy

---