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

Jim,

Try this

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

Mike

"Jim" wrote:

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

Something like:

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

Regards,
Fred

"Jim" wrote in message
...
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.

--
Rick (MVP - Excel)


"Jim" wrote in message
...
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