ExcelBanter - In excel, what does the esclemation point (!) in a function mean?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - In excel, what does the esclemation point (!) in a function mean? (https://www.excelbanter.com/excel-worksheet-functions/34337-excel-what-does-esclemation-point-function-mean.html)

Marsha

In excel, what does the esclemation point (!) in a function mean?

In excel, what does the esclemation point (!) in a function mean?

Hi

It indicates the end of a sheet name. For example: =Sheet1!A16 refers to
cell A16 in Sheet1

Andy.

"Marsha" wrote in message
...
In excel, what does the esclemation point (!) in a function mean?

Bob Phillips

If separates a worksheet name from the range being used, such as

Sheet1!A1:A10

--
HTH

Bob Phillips

"Marsha" wrote in message
...
In excel, what does the esclemation point (!) in a function mean?

All times are GMT +1. The time now is 10:44 PM.