How to isolate portion of thread

[DougStroud]

I need to isolate the number in the cell. I'd like to select the number, cut it and place it in the adjacent cell to the right.

A1 DougStroud.com (DS) - 205,200

Thanks,

Doug

 

[Joe4]

If it is always at the end of the entry, after the "-", then try this formula (for an entry in cell A1):

=TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",100)),100))+0

 

[DougStroud]

Thank you Joe! That is perfect!!!

 

[Joe4]

You are welcome.
Glad I was able to help!

 

[jtakw]

Hi,

Assuming the number is always after the hyphen, only 1 hyphen, nothing behind the number:

Book3.xlsx
	A	B
1	DougStroud.com (DS) - 205,200	205200
Sheet808

Cell Formulas
Range	Formula
B1	B1	=MID(A1,FIND("-",A1)+1,15)+0

PS: I use TRIM for text results, +0 to convert to real number, don't think both are needed, when using +0, Excel with auto-trim if it's 255 spaces or less.