View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
knowshowrosegrows knowshowrosegrows is offline
external usenet poster
 
Posts: 13
Default Text removal question

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