ExcelBanter - when are [ ] brackets used

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

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

- - when are [ ] brackets used (https://www.excelbanter.com/excel-worksheet-functions/207270-when-%5B-%5D-brackets-used.html)

cmat

when are [ ] brackets used

When would use the [ ] brackets in Exce;\l?

Spiky

when are [ ] brackets used

On Oct 21, 2:48*pm, cmat wrote:
When would use the [ ] brackets in Exce;\l?

I think....never. Unless you had some text and wanted brackets.

Pete_UK

when are [ ] brackets used

When you are refering to data in another file, eg:

=[filename.xls]Sheet1!A1

where filename.xls is open.

Do I get the marks for your homework?

Pete

On Oct 21, 8:48*pm, cmat wrote:
When would use the [ ] brackets in Exce;\l?

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