Home 
Search 
Today's Posts 
#1




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 viceversa Salahuddin 
#2




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 viceversa Salahuddin 
#3




How to subtract one text column based on their text column MS
Hello Sheeloo,
Actually I want C which is AB 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 viceversa Salahuddin 
#4




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 AB 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 viceversa Salahuddin 
#5




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 AB 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 viceversa 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) 