A1 and A2 are not columns, so I'm not totally clear where your data is.
Perhaps this normally entered formula does what you want...

=TRIM(RIGHT(SUBSTITUTE(TRIM(A1)," ",REPT(" ",99)),99))

--
Rick (MVP - Excel)


"knowshowrosegrows" wrote in
message ...
I have a column (A1) that has text similar to the following:
Adult Services-DMHAS, Bridgeport A100215249400

I want to take only the text to the right of the last space. The
resulting
column (A2) would have the following text in it:
A100215249400

Can someone tell me the formula for this?--
Thanks

You all are teaching me so much