Formulaneeded for extraction

  • Thread starter Thread starter Sal Iaccarino
  • Start date Start date
S

Sal Iaccarino

I have the following in a cell: 2496 Orchid Bay Dr, Y104
I need a formula to extract the building number "Y104"
The unique characters prior to the building Number are a comma and a blank

Thanks Sal and Eileen
 
Hi Sal!

Try:
=RIGHT(A1,LEN(A1)-FIND(", ",A1)-1)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
If the building number is always the rightmost 4 characters, then

=RIGHT(A1,4)

or you could use the Data > Text to Columns feature using space as a
delimiter.........


Vaya con Dios,
Chuck, CABGx3
 
or you could use the Data > Text to Columns feature using space as a
delimiter.........
Click to expand...

Think you meant comma as a delimiter, but then you probably still have to
TRIM the result.
 
Hey Dave..........

That "TRIM" solution is by far the "coolest", in my book............ain't
it great the way one simple question can solicit so many different ways of
doing the same thing?............Long Live the Newsgroups!!!!!

Vaya con Dios,
Chuck, CABGx3
 
Thanks to all that replied to this post. It is a fantastic way to learn.
Keep it up.

Sal and Eileen
 
Back
Top