Remove text from cell 1 based on values from cell 2?

[mattdavid.hall]

Hi,

Here is my scenario.

Column A has many different values in each cell/row such as "537-195-0 Rev B", "50-5830-294-A DT 07/13/13", and "W-483 Rev d".
Column B has similar values for each cell/row such as "537-195-0", "50-830-294-A", and "W-483".
I want to make Column C be the last half of Column A. See table for example.

Column A	Column B	Column C
537-195-0 Rev B	537-195-0	Rev B
50-5830-294-A DT 07/13/13	50-830-294-A	DT 07/13/13
W-483 Rev d	W-483	Rev d

<tbody>
</tbody>

So column A and B are firm and set. I'm working with column C to extract the last half of column A.
In simple terms I need this: C1=A1-B1.

This has been difficult for me because the length of values in A are never the same.

Is this possible to do?

 

[Rick Rothstein]

Hi,

Here is my scenario.

Column A has many different values in each cell/row such as "537-195-0 Rev B", "50-5830-294-A DT 07/13/13", and "W-483 Rev d".
Column B has similar values for each cell/row such as "537-195-0", "50-830-294-A", and "W-483".
I want to make Column C be the last half of Column A. See table for example.

Column A	Column B	Column C
537-195-0 Rev B	537-195-0	Rev B
50-5830-294-A DT 07/13/13	50-830-294-A	DT 07/13/13
W-483 Rev d	W-483	Rev d

<tbody>
</tbody>

You can produce the values in Columns B and C using these formula...

B1: =LEFT(A1,FIND(" ",A1&" ")-1)

C1: =MID(A1,FIND(" ",A1&" ")+1,LEN(A1))

These formulas may be copied down as needed.

 

[DRSteele]

This just might be what you're looking for:

Excel 2012
	A	B	C
1	537-195-0 Rev B	537-195-0	Rev B
2	50-5830-294-A DT 07/13/13	50-830-294-A	DT 07/13/13
3	W-483 Rev d	W-483	Rev d
Sheet30

Cell Formulas
Range	Formula
C1	=TRIM(REPLACE(A1,1,LEN(B1)+1,""))
C2	=TRIM(REPLACE(A2,1,LEN(B2)+1,""))
C3	=TRIM(REPLACE(A3,1,LEN(B3)+1,""))

 

[mattdavid.hall]

DRSteele, that did it! Thanks a lot mate!

 

[mattdavid.hall]

Rick, your solution worked as well. Thanks for the suggestion!

 

[DRSteele]

You're most welcome. I'm glad I helped.