How do I delete only part of the data in a row of cells?

G

Guest

My column B contains a series of numbers with a space then a part#. All I
want to keep in this row is the part#, I need to get rid of the numbers
before it. Help? Here is an example: Cell B46 contains "205 234457-B22",
cell B47 contains "206 332558-B21", etc...I need to figure out how to
delete 205, 206, etc from these cells as there are thousands of them and I
don't want to do
 
P

PCLIVE

You can use a helper column to get the numbers you want, and then copy and
paste (paste special) that column (values only) over the original column.

The formula you could use:
=RIGHT(B47,LEN(B47)-FIND(" ",B47))

However, in your examples, there are two spaces. Not just one. If this
will always be the case, then:
=RIGHT(B47,LEN(B47)-FIND(" ",B47)-1)

HTH,
Paul
 

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

Vlookup with part of cell text 3
blank cell instead of x 2
Sum Count of Numeric Duplicates: appears x2 in any Row 19
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
search for and return more than one row in a sheet 1
Delete duplicates in a row 3
Excel Drag autofill only part of formula 3
Excel Add ^ to a row of cells containing letters 3

Top