Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete asterik mark
Hi
Is there anyway I can delete the asterik mark in front of the ID#? I have over 1200 ID#s with asterik mark. Thank you ID # * 765 * 4059 * 4793 * 2638 * 5302 * 5494 * 4057 * 5311 * 4823 * 5607 * 1276 * 5413 * 2585 * 5659 * 4001 * 5645 * 2217 * 4054 * 2265 * 2105 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete asterik mark
you should be able to use Edit Find/Replace:
in the Find box put: * leave the replace box blank "da" wrote: Hi Is there anyway I can delete the asterik mark in front of the ID#? I have over 1200 ID#s with asterik mark. Thank you ID # * 765 * 4059 * 4793 * 2638 * 5302 * 5494 * 4057 * 5311 * 4823 * 5607 * 1276 * 5413 * 2585 * 5659 * 4001 * 5645 * 2217 * 4054 * 2265 * 2105 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete asterik mark
Use the 'Find and Replace' option
--Select the column/range and hit Ctrl+H --Hit 'Options' in Find/Replace window. --Make sure you select 'Formulas' in 'Look In' --Find What: ~* --Replace With: (leave this blank) --Hit Replace All If this post helps click Yes --------------- Jacob Skaria "da" wrote: Hi Is there anyway I can delete the asterik mark in front of the ID#? I have over 1200 ID#s with asterik mark. Thank you ID # * 765 * 4059 * 4793 * 2638 * 5302 * 5494 * 4057 * 5311 * 4823 * 5607 * 1276 * 5413 * 2585 * 5659 * 4001 * 5645 * 2217 * 4054 * 2265 * 2105 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete asterik mark
Say your ID's in Col A. Insert a helper column next to it. Enter
=RIGHT(A1,LEN(A1)-2), and copy down. Block the new ID's, copy and Paste Special as values. Delete Col A. -- HTH Kassie Replace xxx with hotmail "da" wrote: Hi Is there anyway I can delete the asterik mark in front of the ID#? I have over 1200 ID#s with asterik mark. Thank you ID # * 765 * 4059 * 4793 * 2638 * 5302 * 5494 * 4057 * 5311 * 4823 * 5607 * 1276 * 5413 * 2585 * 5659 * 4001 * 5645 * 2217 * 4054 * 2265 * 2105 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Delete asterik mark
Thank you. It worked like a charm.
"da" wrote: Hi Is there anyway I can delete the asterik mark in front of the ID#? I have over 1200 ID#s with asterik mark. Thank you ID # * 765 * 4059 * 4793 * 2638 * 5302 * 5494 * 4057 * 5311 * 4823 * 5607 * 1276 * 5413 * 2585 * 5659 * 4001 * 5645 * 2217 * 4054 * 2265 * 2105 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Foot mark aka single quote mark? | Excel Worksheet Functions | |||
How can I add active tick mark/check mark boxes in excel? | Excel Discussion (Misc queries) | |||
# mark | Excel Worksheet Functions | |||
How can I find an asterik "*" in a spreadsheet using ctrl+F? | Excel Discussion (Misc queries) | |||
Mark entire row | Excel Discussion (Misc queries) |