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!

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!

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!
>