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

#### mattdavid.hall

##### New Member
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?

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
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.

This just might be what you're looking for:

Excel 2012
ABC
1537-195-0 Rev B537-195-0Rev B
3W-483 Rev dW-483Rev d
Sheet30
Cell Formulas
RangeFormula
C1=TRIM(REPLACE(A1,1,LEN(B1)+1,""))
C2=TRIM(REPLACE(A2,1,LEN(B2)+1,""))
C3=TRIM(REPLACE(A3,1,LEN(B3)+1,""))

DRSteele, that did it! Thanks a lot mate!

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

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

Replies
2
Views
64
Replies
5
Views
137
Replies
2
Views
194
Replies
3
Views
116
Replies
3
Views
76

1,203,563
Messages
6,056,092
Members
444,846
Latest member
pbailey

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back