| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to subtract one text column based on their text column MS xls.
How to subtract one text column based on their text column MS xls.
A B Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 VIC 3807 26 Currajong Avenue SELBY VIC 3159 VIC 3159 I want to subtract column B from column A or vice-versa Salahuddin |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to subtract one text column based on their text column MS xls.
What do you mean subtract? In the example given by you what will be the
outcome? "Salahuddin" wrote: How to subtract one text column based on their text column MS xls. A B Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 VIC 3807 26 Currajong Avenue SELBY VIC 3159 VIC 3159 I want to subtract column B from column A or vice-versa Salahuddin |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to subtract one text column based on their text column MS
Hello Sheeloo,
Actually I want C which is A-B for example Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 (A) - VIC 3807 (B) In column (C) i want it as Shop 18, 55 Princes Highway BEACONSFIELD same for the folloing 26 Currajong Avenue SELBY VIC 3159 (A) - VIC 3159 (B) = 26 Currajong Avenue SELBY (C) Cheers Salahddin "Sheeloo" wrote: What do you mean subtract? In the example given by you what will be the outcome? "Salahuddin" wrote: How to subtract one text column based on their text column MS xls. A B Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 VIC 3807 26 Currajong Avenue SELBY VIC 3159 VIC 3159 I want to subtract column B from column A or vice-versa Salahuddin |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to subtract one text column based on their text column MS
Put this in C1 and copy down
=SUBSTITUTE(A1,B1,"") If you want to remove is at the end then you can use =LEFT(A1, LEN(A1)-LEN(B1)) Both will leave a blank at the end... "Salahuddin" wrote: Hello Sheeloo, Actually I want C which is A-B for example Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 (A) - VIC 3807 (B) In column (C) i want it as Shop 18, 55 Princes Highway BEACONSFIELD same for the folloing 26 Currajong Avenue SELBY VIC 3159 (A) - VIC 3159 (B) = 26 Currajong Avenue SELBY (C) Cheers Salahddin "Sheeloo" wrote: What do you mean subtract? In the example given by you what will be the outcome? "Salahuddin" wrote: How to subtract one text column based on their text column MS xls. A B Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 VIC 3807 26 Currajong Avenue SELBY VIC 3159 VIC 3159 I want to subtract column B from column A or vice-versa Salahuddin |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to subtract one text column based on their text column MS
Hello Sheeloo
It works. Thanks for your help. Salahuddin "Sheeloo" wrote: Put this in C1 and copy down =SUBSTITUTE(A1,B1,"") If you want to remove is at the end then you can use =LEFT(A1, LEN(A1)-LEN(B1)) Both will leave a blank at the end... "Salahuddin" wrote: Hello Sheeloo, Actually I want C which is A-B for example Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 (A) - VIC 3807 (B) In column (C) i want it as Shop 18, 55 Princes Highway BEACONSFIELD same for the folloing 26 Currajong Avenue SELBY VIC 3159 (A) - VIC 3159 (B) = 26 Currajong Avenue SELBY (C) Cheers Salahddin "Sheeloo" wrote: What do you mean subtract? In the example given by you what will be the outcome? "Salahuddin" wrote: How to subtract one text column based on their text column MS xls. A B Shop 18, 55 Princes Highway BEACONSFIELD VIC 3807 VIC 3807 26 Currajong Avenue SELBY VIC 3159 VIC 3159 I want to subtract column B from column A or vice-versa Salahuddin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Worksheet Functions | |||
| Text to column and selecting values based on a different column | Excel Discussion (Misc queries) | |||
| Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) | |||
Linear Mode
