Truncating Data

Giganews Newsgroups
Subject: Truncating Data
Posted by:  JC (jcarls…@ti.com)
Date: Wed, 29 Oct 2003

I have a number of cells that has data -
Address:  123 Main St.

I want to write a function the removes the Address:
portion.  I can't use the Right(A1, 12) because the actual
street addres changes in length.  What function will do
this?

TIA, JC

Replies