View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Salahuddin[_2_] Salahuddin[_2_] is offline
external usenet poster
 
Posts: 2
Default 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