How to delete part of a Microsoft Excel cell

1160675 pts.
Tags:
Microsoft Excel
Okay, so I have an interesting question. I was sent a Microsoft Excel spreadsheet and I need to delete parts of different cells. Meaning everything after this symbol '*' needs to be deleted (including the symbol). For example:
JohnSmith*22101
This is how it should look after:
JohnSmith
It's too difficult to do it manually (there are thousands of cells).
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

Depending on what you want to strip out you could try using FIND / REPLACE.

Otherwise it’s a matter of creating formulas to handle the removal and store the new value in a new cell. If there are that many cells you may want to create the new cells on a new tab.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Subhendu Sen
    Open the file in Excel. You may select the column/cell(s) then choose Find/ Replace option. Now use * for Find What box, & leave the Replace with a blank or no space. Now check Match entire cell contents or excel replaces every *. It may change slightly depending on version to versions.
    144,140 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: