Convert into figure

[sachar]

Dear All,

With reference to the attach sample that I received as the amount [column”E”] which I want to convert into the figure with the help of a formula like; [Column”F”].

Can be possible?

 

[r1c1]

@sachar
Try this formula

=VALUE(LEFT(E2,FIND("/",E2)-1))

 

[sachar]

Dear r1c1,

Thanks to you for figure out my problem.

 

[Kevin@Radstock]

Use Text to Columns on the Data Tab

 

[sachar]

Dear Kevin,

Received with thanks and very simple way!