excel formula...please...help..

C

cryptus

New Member
Joined
Sep 23, 2002
Messages
1
i need to get the difference of two columns in numbers that will also fit in words or letters...


column a column b column c
robot rob ot

OR

column a column b column c

14 12 2


please help me..... thank you!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
Try to fit

=IF(ISNUMBER(A1),A1-B1,IF(LEN(A1)>LEN(B1),SUBSTITUTE(A1,B1,""),SUBSTITUTE(B1,A1,"")))

to whatever your real problem is.
 
Upvote 0
You must log in or register to reply here.

Similar threads

dcofer
  • Solved
Locating Words With Specific Letters in a Column
Replies
5
Views
153
dcofer
dcofer
S
  • Solved
Calculating Multiple Columns with SUMIFS
Replies
3
Views
197
Joe4
Joe4
J
  • Solved
Index and Match should be my best option?
Replies
5
Views
346
Fluff
Fluff
E
  • Solved
Formula to Auto Subtract Cells That Change Weekly
Replies
4
Views
94
6StringJazzer
6StringJazzer
C
  • Question
Excel Userform Listbox Search issues
Replies
3
Views
125
Akuini
Akuini

Forum statistics

Threads
1,214,947
Messages
6,122,413
Members
449,082
Latest member
tish101

Share this page

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top