ExcelBanter - what is ; (semi colon) in excel, what does it do

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what is ; (semi colon) in excel, what does it do (https://www.excelbanter.com/excel-discussion-misc-queries/258846-what-%3B-semi-colon-excel-what-does-do.html)

grog

what is ; (semi colon) in excel, what does it do

Dennis Tucker

what is ; (semi colon) in excel, what does it do

In Excel worksheets the semicolon is just another printable character. In
VB/VBA it has some special meanings like on Print # statements it is used to
stop the insertion of the new line character.

"grog" wrote in message
...

Gord Dibben

what is ; (semi colon) in excel, what does it do

Could be a separator in some Language Settings.

i.e. used in place of a comma.

=SUM(A1;B1;C1)

Gord Dibben MS Excel MVP

On Sat, 13 Mar 2010 21:28:01 -0800, grog
wrote:

All times are GMT +1. The time now is 03:58 PM.