DELETING IN A CELL

  • Thread starter Completely Confused
  • Start date
C

Completely Confused

How do I delete numbers in a cell. I have a long column and I need to have
the numbers look like this. Is there a formula?

numbers look like this: 1420-01-235-6522
2542-00-155-5689
5879-00-256-9987

I need to make them look like this:

012356522
001555689
002569987

Thank you for your help
 
B

Bob I

Copy right most 11 characters to new column and then find and replace
"-" with blank "" (nothing)
 
R

Rob Giordano \(Crash\)

Try Data | Text to Columns and you can split on the first - as a delimiter.
Select your Column first.

Then you could do a search and replace to get rid of the rest of the dashes.

hth


in message | How do I delete numbers in a cell. I have a long column and I need to
have
| the numbers look like this. Is there a formula?
|
| numbers look like this: 1420-01-235-6522
| 2542-00-155-5689
| 5879-00-256-9987
|
| I need to make them look like this:
|
| 012356522
| 001555689
| 002569987
|
| Thank you for your help
 
Top