Deleting last character

[ptrifile]

I have a spreadsheet with one column that has over 2000 rows. It was exported from another application and all of them have a $ at the end of the number.....is there a way to delete the last character for all of them at once? Any help is appreciated!

Thanks!

Paul

 

[SkipVought]

Hi,

There's Edit/Replace.

There's Data/Text to columns.

There's =Left(YourCellRef,Len(YourCellRef)-1)

Skip,

_[red][/red]