Truncating Data

  • Thread starter Thread starter JC
  • Start date Start date
J

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
 
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 (e-mail address removed)
 
Back
Top