Need help with Text Functions

  • Thread starter Thread starter Shams
  • Start date Start date
S

Shams

Folks,
I am trying to save myself some redundant typing by using
text function:

I have the following Subtotals by Addresses:

Subtotal 50th Ave. & John Street

Subtotal 14th St. & Marquette Avenue

I want to be able to create a formula where I can
concatenate the text "TOTAL" with the addresses from
above. So, it should read: TOTAL 50th Avenue & John
Street.

Can I use a trim/clean function to get rid of the subtotal
from the body of the text? I would appreciate your help.
Thanks.
 
Hi

Try this:
="TOTAL "& MID(A2,10,999)

Or you could just use Find Replace. Find: Subtotal Replace: TOTAL
 
Hi

With your text in cell A2, the formula will be
=SUBSTITUTE(A2,"Subtotals","TOTAL")
 
Back
Top