Text removal question

  • Thread starter Thread starter knowshowrosegrows
  • Start date Start date
K

knowshowrosegrows

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
 
=RIGHT(A1,MATCH(" ",MID(A1,LEN(A1)-ROW(INDIRECT("1:"&LEN(A1))),1),0))
This is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key.
 
Shazam!

That was a quick reply. Thanks

There are about four concepts in that formula that I will need to read up on
to understand. Great -

Unfortunately, when I pasted it in and hit CNTRL-SHFT-ENTER I got #N/A. Any
ideas?
 
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))
 
While I think the formula I just posted may be a little more efficient than
this one, I'm thinking your problem with the formula Gary''s Student posted
might be in where you pasted it. If you pasted it directly into the cell,
Ctrl+Shift+Enter won't work... you have to paste the formula directly into
the Formula Bar and then hit Ctrl+Shift+Enter from that location.
 
Back
Top