software

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 quot; infront of the data in the cell and quot; } 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

=quot;quot;quot;quot;amp;CELLamp;quot;}quot;

Change Cell to the Cell reference you need.

Regards

Govind.Clare wrote:
gt; I want to be able to add a suffix and prefix to a column of data that has
gt; been imported into an excel file without changing each cell individually.
gt; Does anyone know of a function that will do this?
gt;
gt; I just want to be able to put quot; infront of the data in the cell and quot; } at
gt; the end. this is so that the data can then upload into an HP 48G calculator
gt; that is running a program.
gt;
gt; Help would be greatly appreciated as I am getting tired of changing 80 plus
gt; cells!

Thanks a million
you have saved me so much time!quot;Govindquot; wrote:

gt; Hi,
gt;
gt; Use
gt;
gt; =quot;quot;quot;quot;amp;CELLamp;quot;}quot;
gt;
gt; Change Cell to the Cell reference you need.
gt;
gt; Regards
gt;
gt; Govind.
gt;
gt;
gt; Clare wrote:
gt; gt; I want to be able to add a suffix and prefix to a column of data that has
gt; gt; been imported into an excel file without changing each cell individually.
gt; gt; Does anyone know of a function that will do this?
gt; gt;
gt; gt; I just want to be able to put quot; infront of the data in the cell and quot; } at
gt; gt; the end. this is so that the data can then upload into an HP 48G calculator
gt; gt; that is running a program.
gt; gt;
gt; gt; Help would be greatly appreciated as I am getting tired of changing 80 plus
gt; gt; cells!
gt;