Deleting Parts of a Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You can create a query to do that for you.

Select TableName.*, Left([FieldName],instr([FieldName],"/")-1) As NewField
From TableName
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record-Locking remains open after closing 0
Deleting Parts of Cells 2
MS word Find and Replace using Regex - Help required 0
Best PST Recovery Software 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel How do I delete images in a specific range 1
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0
News 419m phone numbers leaked in Facebook data breach 3

Back
Top