Deleting Parts of Cells

  • 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 could bring it into Excel as a txt file
open the txt file in excel
Text Import Wizard will appear
select >delimited
check > other and type the "/" into the box
finish
you should have a separation where the / was.
 
Hi GOL. Assuming your list starts in A2, you could enter the following
formula in B2 and copy down to match your list in Column A. When finished,
you might want to copy Column B and paste special>values over itself:
=LEFT(A2,SEARCH("/",A2,1)-1) HTH
 
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

Extracting/deleting select data from range of cell 4
Deleting Parts of a Cell 1
Reference only part of a cell 7
Need help deleting data 2
MS word Find and Replace using Regex - Help required 0
Best PST Recovery Software 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel Query setup 0

Back
Top