Cleaning a cell

  • Thread starter Thread starter Scottmk
  • Start date Start date
S

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
 
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
 
Back
Top