Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting symbols front and
in column a i have 300+ numbers and i want to put a * sign in on both side of
numbers in order to look it up. my question is that is there a fast way of putting that (*)symbol in rather then doing in indiviually and same for taking it out? i.E A *159* *123* Faster way of putting star? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting symbols front and
if you goto format cells number custom and then in the custom box type "*"#####"*" this should work for you -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=557722 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
putting symbols front and
Formatting the * in place will only make it LOOK like they are
there..........if you really want them there, In a helper column put this formula and copy down.........then do Copy PasteSpecial Values on the column to eliminate the formulas and delete the original column if desired............ ="*"&A1&"*" Vaya con Dios, Chuck, CABGx3 "Jammal" wrote in message ... in column a i have 300+ numbers and i want to put a * sign in on both side of numbers in order to look it up. my question is that is there a fast way of putting that (*)symbol in rather then doing in indiviually and same for taking it out? i.E A *159* *123* Faster way of putting star? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Symbols in Drop Down Lists | Excel Worksheet Functions | |||
Web Query With Multiple Stock Symbols & Stock Scouter | Excel Worksheet Functions | |||
inserting symbols not available in excel | Excel Discussion (Misc queries) | |||
putting leading zeros in front of number | Excel Discussion (Misc queries) | |||
Using symbols for drop down list boxes? | Excel Worksheet Functions |