How to remove asterisks from a column in Excel

Is the format the same for all the rows, i.e. **1234?

If so, you may try: text to column > fixed width and split the asterisks from the numbers.

 

Just highlight the column in question, control f, find **, replace with nothing. Boom, all set.

 

Really? That's strange. Are all the numbers like this: "**1234" ? Perhaps try copying the column and then pasting it into a new column, but do paste special "value", and then try to control f and replace all the "**" with nothing.

 

=right(cell, LEN(cell)-# of characters to remove)

 

to parrot above, if

A1 = **1234

Then in B1, do =right(a1,4)

Right pulls from the right the last [x] items of the cell you reference.

 

Control + h

You're welcome.

 

I've had that happen. It's not supposed to, but Excel gets wonky sometimes. Donkey's and Jay's solution should work. You might also be able to copy everything, open a new workbook and paste values (be sure it's values only, not everything), and then do the Find/Replace trick on the new file. It might still not work though.

 

Pretty much what DonkeyMagic said.....

=right(a1,4)

That should take the 4 characters furthest to the right in the cell.

 

one option is to click on the cell, delete the asterisks, and then do the same for all the other cells

 

I heard alt+f4 removes all of the asterisks from your screen

 

It's simple. a 5 year old knows this.

Go to the cell, click right after the 2nd asterisk and then hit backspace twice. Then repeat this process