how do i make a semicolon appear in every cell

[paul]

[Bearacade]

You can make a Macro:

Sub AllSemicolon()

Cells.Select
Selection.Value = ";"

End Sub

[Dave Peterson]

Or select the range you want
type the semicolon
hit ctrl-enter
to fill all the selected cells with that character.

paul wrote:

--

Dave Peterson