Eliminate Colon and Space

[Jim]

Hello,

I have a column of data that returns data that looks like this:

: CMCKX

I need to eleminate the colon and the space with a formula.

Can you help?

Thanks
Jim

 

[Mike H]

Jim,

Try this

=TRIM(MID(A1,FIND(":",A1)+1,LEN(A1)))

Mike

 

[Fred Smith]

Something like:

=right(a1,len(a1)-2)

Regards,
Fred

 

[Rick Rothstein]

Are you trying to remove those characters permanently from the cell
containing them (as opposed to putting the values without them in some other
column, which is all a formula can do for you)? If so, you can use
Edit/Replace from the menu bar... just select all the cells in the column,
use colon/space (type those two characters) in the "Find what" field, leave
the "Replace with" field empty, and then click the "Replace All" button.