Removing multiple instances of a character

[Jaryd]

Hello,

I have been a casual read of these forums for a while. This is my first post.

I was hoping someone could help me. I would prefer VBA code, but a forumla would be fine too

I pull reports and some of the information that comes in I need to clean up so filters can be used. I am trying to find a faster way to do this. It is currently the only part of the clean up I do manually. The best pattern I found is all the text I want to keep is after the last "."

There can be 1 through 3 "."s in each cell. So I could not get Text to Columns to work.

Any help would be great. Thanks

 

[Jaryd]

I have generally had good luck finding what I need for excel. I guess I had issues with the wording on this.

I put off asking for help on this for a while. I can't believe how responsive everyone is. It really is amazing.

njimack, kevatarvind: I could not get yours to work. I am mostly just testing for learning purposes. I am getting #value! error on both. I did not really look into them that well since Akashwani's worked.

However, I did add =Trim to Akashwani's formula to remove the extra beginning space coming over.

EDIT: I found out what I was doing wrong with njimack & kevatarvind's post. I was changing the cell reference to D1 when i needed them at D2

 

[kevatarvind]

Thanks For the feedback

Glad To help

 

[Jaryd]

Rick Rothstein,

I can't believe I could do it with Find & Replace... And that VBA code is so simple.


Wow the asterisk in the find & replace is something I can really take away from this

Thanks.

 

[Akashwani]

There surely is more than one way to skin a cat and more than one solution to an Excel problem

Ak