Eliminate Colon and Space

  • Thread starter Thread starter Jim
  • Start date Start date
J

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
 
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.
 
Back
Top