• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 228
  • Last Modified:

Need a macro to remove TEXT at end of Cell Entry in a column....

Experts,

My data in the column looks like this:

ModificationDateEntity.52
DatacheckEntity.52
lalalalaEntity.52
SampleSampleEntity.52

I need a macro or whatever that will check for the "Entity.52" and simply remove it from the cells that have this entry....

If its easier to copy this column into another column that is "cleansed" that works for me....


Thank you for your expertise.


0
MIKE
Asked:
MIKE
  • 3
  • 2
  • 2
3 Solutions
 
MIKESoftware Solutions ConsultantAuthor Commented:
Additional INFO!!!!   the end NUMBER on "Entity.52" ....INCREMENTS....and so its not always 52 as in my example.... I think it can go to 3 digits as well.....sorry for not explaining...
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Are you trying to remove the text .52?

why don't you do a simple replace?

Replace all .52 with ""
0
 
Ardhendu SarangiSr. Project ManagerCommented:
Sorry i saw your 2nd comment after posting... can you then post a sample spreadsheet?
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Brian GeeCommented:
A quick, macro-less way to do this is to select the column in question, then initiate a Find and Replace.

Find what: Entity.52
Replace with:


Note that the Replace with: above is intentionally blank.
0
 
MIKESoftware Solutions ConsultantAuthor Commented:
Thanks guys...believe it or not, I'm a SQL guy and just didn't think it through....long day.....so thanks....yes I'll use REPLACE.......thanks for the help!
0
 
Brian GeeCommented:
With the new criteria (that I see) in mind, use this:

Find what: Entity.*
Replace with:
0
 
Ardhendu SarangiSr. Project ManagerCommented:
just didn't think it through....long day.....so thanks --


Happens to all of us... glad it worked out for ya! :)
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now