Prefix and Suffix
 

I want to be able to add a suffix and prefix to a column of data that has
been imported into an excel file without changing each cell individually.
Does anyone know of a function that will do this?

I just want to be able to put " infront of the data in the cell and " } at
the end. this is so that the data can then upload into an HP 48G+ calculator
that is running a program.

Help would be greatly appreciated as I am getting tired of changing 80 plus
cells!

Prefix and Suffix
 

Hi,

Use

=""""&CELL&"}"

Change Cell to the Cell reference you need.

Regards

Govind.


Clare wrote:
I want to be able to add a suffix and prefix to a column of data that has
been imported into an excel file without changing each cell individually.
Does anyone know of a function that will do this?

I just want to be able to put " infront of the data in the cell and " } at
the end. this is so that the data can then upload into an HP 48G+ calculator
that is running a program.

Help would be greatly appreciated as I am getting tired of changing 80 plus
cells!

Prefix and Suffix
 

Thanks a million :)
you have saved me so much time!


"Govind" wrote:

Hi,

Use

=""""&CELL&"}"

Change Cell to the Cell reference you need.

Regards

Govind.


Clare wrote:
I want to be able to add a suffix and prefix to a column of data that has
been imported into an excel file without changing each cell individually.
Does anyone know of a function that will do this?

I just want to be able to put " infront of the data in the cell and " } at
the end. this is so that the data can then upload into an HP 48G+ calculator
that is running a program.

Help would be greatly appreciated as I am getting tired of changing 80 plus
cells!