Auto enclosing a value in brackets

[Guest]

I'm working on a csv file that has all its values enclosed in brackets []. I have to create about 200 more lines of data. Is there a formula that will automatically enclose anything I type, in brackets? ex. [Word]

Thanks

 

[Bernie Deitrick]

Bad Fish,

Use a custom format of

;;;"["@"]"

for all cells that you want to type strings into.

If you also need to do that for any numbers, then use something like this,
for 2 decimal places:

"["0.00"]";"["-0.00"]";"["0.00"]";"["@"]"

HTH,
Bernie
MS Excel MVP

I'm working on a csv file that has all its values enclosed in brackets [].

I have to create about 200 more lines of data. Is there a formula that will
automatically enclose anything I type, in brackets? ex. [Word]

 

[Stephen Dunn]

Hi Bernie,

Would that provide the required output in a csv file?

Bad Fish,

Use a custom format of

;;;"["@"]"

for all cells that you want to type strings into.

If you also need to do that for any numbers, then use something like this,
for 2 decimal places:

"["0.00"]";"["-0.00"]";"["0.00"]";"["@"]"

HTH,
Bernie
MS Excel MVP

I'm working on a csv file that has all its values enclosed in brackets

[].
I have to create about 200 more lines of data. Is there a formula that will
automatically enclose anything I type, in brackets? ex. [Word]

Thanks

 

[Stephen Dunn]

One way would be to have a formula such as:

="["&A1&"]"

in each cell (to the extent of your data) of another sheet. When your data
input is finished you could then Copy them all, then Edit>Paste Special>As
Values, and delete the original sheet.

I'm working on a csv file that has all its values enclosed in brackets [].

I have to create about 200 more lines of data. Is there a formula that will
automatically enclose anything I type, in brackets? ex. [Word]

 

[Bernie Deitrick]

Yes. When you save an Excel File as a CSV file, the formatted data is used
as the output to the file.

HTH,
Bernie
MS Excel MVP

Hi Bernie,

Would that provide the required output in a csv file?

Bad Fish,

Use a custom format of

;;;"["@"]"

for all cells that you want to type strings into.

If you also need to do that for any numbers, then use something like this,
for 2 decimal places:

"["0.00"]";"["-0.00"]";"["0.00"]";"["@"]"

HTH,
Bernie
MS Excel MVP

I'm working on a csv file that has all its values enclosed in brackets

[].
I have to create about 200 more lines of data. Is there a formula that will
automatically enclose anything I type, in brackets? ex. [Word]

Thanks

 

[Stephen Dunn]

Cheers.

Yes. When you save an Excel File as a CSV file, the formatted data is used
as the output to the file.

HTH,
Bernie
MS Excel MVP

Hi Bernie,

Would that provide the required output in a csv file?

Bad Fish,

Use a custom format of

;;;"["@"]"

<snip>

 

[Stephen Dunn]

Ignore. Use Bernie's solution.

One way would be to have a formula such as:

="["&A1&"]"

in each cell (to the extent of your data) of another sheet. When your data
input is finished you could then Copy them all, then Edit>Paste Special>As
Values, and delete the original sheet.

I'm working on a csv file that has all its values enclosed in brackets

[].
I have to create about 200 more lines of data. Is there a formula that will
automatically enclose anything I type, in brackets? ex. [Word]

Thanks

 

[Mark]

Thanks for the info. Its working wonders now! GO BERNIE!

-----Original Message-----
Yes. When you save an Excel File as a CSV file, the formatted data is used
as the output to the file.

HTH,
Bernie
MS Excel MVP

Hi Bernie,

Would that provide the required output in a csv file?

Bad Fish,

Use a custom format of

;;;"["@"]"

for all cells that you want to type strings into.

If you also need to do that for any numbers, then use

something like
this,

for 2 decimal places:

"["0.00"]";"["-0.00"]";"["0.00"]";"["@"]"

HTH,
Bernie
MS Excel MVP

news:B82FB192-DBA0-4AAA-A52A- (e-mail address removed)...
I'm working on a csv file that has all its values

enclosed in brackets
[].

I have to create about 200 more lines of data. Is

there a formula that
will

automatically enclose anything I type, in brackets? ex. [Word]

Thanks

.