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


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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

On Wed, 19 Nov 2003 10:33:58 -0600, Scottmk
<(E-Mail Removed)> wrote:

>
>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
>
>
>------------------------------------------------
>~~ Message posted from http://www.ExcelTip.com/
>~~View and post usenet messages directly from http://www.ExcelForum.com/

Thank

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com