Cleaning a cell

[Scottmk]

Hello, Ive got data that looks like this in a row of cells:
1997 03 775.44
All I want is the 5.44. Any suggestions on how to quickly remove the
unwanted data.
Thanks
Scott

 

[Gord Dibben]

Scott

If the data is structured per your example.

In an adjacent row enter =RIGHT(A1,4)

Drag/copy across the row.

If you want to get rid of the original row, copy the new row and Paste
Special>Values onto itself then delete the original.

Gord Dibben XL2002

 

[Scottmk]

Thank