Adding characters

A

Amy Johnson

Is there a way to add an * be for and after a number I have in a spreadsheet?
I would have a list of numbers such as

56892
56893
56894

I would need to convert them to read

*56892*
*56893*
*56894*

Any help would be appreciated
 
Z

zackb

Hi Amy,

You can use Custom Format if you'd like. This means that it will keep your
values as actual numerics (assuming that they are numerics to start with).
Select all cells in question, hit Ctrl + 1, Number (tab), select Custom on
left and enter this in the textbox on right ..

"*"0"*"

Remember, formatting is only a "mask" and does not influence the cell value
in any way.
 
J

Judy

use the "concatenate" function or just type in a new column
=concatenate(*,[your cell #],*)
 
C

CLR

Backup your file first, then.....

Assuming your numbers are in column A, put this formula in B1 and copy
down.......

="*"&A1&"*"

Then highlight column B and do Copy > PasteSpecial > Values........then you
can delete your old column A if you wish.....

Vaya con Dios,
Chuck, CABGx3
 
Top