Deleting Parts of a Cell

G

GOL

I have a list of information in a column. All the information has the format
of having numbers and letters then a / and more data. I only want to look at
the data to the left of the /. So, I would like the data to the right of the
/ deleted, including the /. For example, I need YYY9/5 to read YYY9. Any
suggestions?
 
O

Ofer

You can create a query to do that for you.

Select TableName.*, Left([FieldName],instr([FieldName],"/")-1) As NewField
From TableName
 
Top