Trim right

[EraseGrey]

I searched and was unable to find something that fixed my problem so sorry if this is a repost.
I'm trying to create a macro that deletes the first part of a string in ever cell in a column. the format is Company:Part# and i want to delete the company name and colon and only leave the part# in the cell for every cell. i've gotten it to work using trim right function within a cell in excel but i need to do it in a macro. Right now i have this and it errors at the find function.

Please Login or Register  to view this content.

[stanleydgromjr]

EraseGrey,

Welcome to the Excel Forum.


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

Please Login or Register  to view this content.

[EraseGrey]

Stan;
That gives me a Type Mismatch error. And of course i'm using a backup! Thank you for the response by the way.
EG.

[romperstomper]

If that's the only colon in the cell, then select the data, press ctrl+h, enter *: on the find box, leave the replace box blank and press Replace All.

[EraseGrey]

Sorry Romp, that just deletes everything.

[romperstomper]

That would only happen if the cells all end in a colon too?
Edit: oh, or if you entered just * in the Find box and not *:

[Alf]

This macro will trim a number of cells in a given range replacing "text" and ":" with "".

Perhaps you can adjust it to fit your needs?

Please Login or Register  to view this content.

[EraseGrey]

That would only happen if the cells all end in a colon too?
Edit: oh, or if you entered just * in the Find box and not *:

Ok wow, i didn't see that colon. It works great now. Thank you