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
|