MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How can i round AS98/BULK/TONNE so that it displays AS98


Posted by Phil on June 01, 2001 4:58 AM

Hi all,

Does any1 know how to round text down to the first delimiter...

Thanxs

Phil


Posted by Dax on June 01, 2001 5:16 AM

Hello,

You could use Data, Text to Columns and choose / as your delimter. Alternatively, you could use a formula such as this: -

=LEFT(A1,SEARCH("/",A1)-1)

Regards,
Dax.

Posted by Aladin Akyurek on June 01, 2001 5:17 AM


=LEFT(A1,SEARCH("/",A1)-1)

where A1 contains the text/string you want to "round text down to the first delimiter."

Aladin