Truncating Data

[JC]

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

 

[Chip Pearson]

JC,

Try something like the following:

=TRIM(MID(A1,FIND(" ",A1),LEN(A1)))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]