Deleting Parts of a Cell

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6628-deleting-parts-of-a-cell.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6628
suggestions?

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

You can create a query to do that for you.

Select TableName.*, Left([FieldName],instr([FieldName],"/")-1) As NewField
From TableName
--
If I answered your question, please mark it as an answer. That way, it will
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6628
stay saved for a longer time, so other can benefit from it.

Good luck



"GOL" wrote:

> I have a list of information in a column. All the information has the format
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6628
> 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?