I've been asked to remove all the character that appear after the following sign "/"

So "D600/1" Should become "D600" and "D241/5" should become "D241"

So i thought my formula would look something like this

=IF(A2, "/", then LEFT(A2, 4) ELSE, A2)

will this work

please see attached excel for example

Hello,

You can use the following formula:
Regards,

Ax

Hi akhlaq768,
That formula's not quite right... it's a bit of a formula / VB combination!

I can't download your attachment - the zip file seems to be corrupted - but I think a formula that would suit you is this:

Alternatively, if you don't want to keep the original data and just want to remove the unwanted characters in situ, then the Text To Columns feature would be a quick and easy option.
Select the range > Data > Text To Columns > Delimited > Other = / > Select the 2nd column in the data preview pane and choose Do Not Import > Finish.


Hope that helps...

thanks guys this is perfect