this would be to time consuming to do daily.


Tom Ogilvy wrote:
Assuming the character is not a number and that it is actually stored in the
cell (making the whole cell a text string) rather than produced through
formatting.

select the column and do Edit=Replace

What: }
With: J

--
Regards,
Tom Ogilvy


"Tony" wrote:

Hello all,

I have a request from a Business Unit and I am baffled.

We will be getting an excel spreadsheet each day and the amounts in a
particular column will change as will the number of rows.

i need to replace the last character in the amount with a particular
alpha character.

example:

20.50 = 20.5}
65.01 = 65.0J

it only changes the last penny.

if anyone could help on this, i would greatly appreciate it. i am not
savvy in this.

thanks,
tony