Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove # Symbol
I have column with strings of text that has the # symbol in front.
#1234567891011 I need to remove the # symbol. Text to columns does not work with (fixed with). Thanks: Teddy-B |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove # Symbol
Same deal, use "Edit", "Replace" (and leave Replace with blank)
-- If my posting was helpful, please click the "Yes" button. ROCK ON!, Scott "Teddy-B" wrote: I have column with strings of text that has the # symbol in front. #1234567891011 I need to remove the # symbol. Text to columns does not work with (fixed with). Thanks: Teddy-B |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove # Symbol
Insert a new column next to the existing data, and use a formula like
=RIGHT(A1,LEN(A1)-1) where A1 is the first cell with data. Copy this down as far as you need to go. Then copy this range and Paste Special Values over the original range and finally delete the range with the formulas. Cordially, Chip Pearson Microsoft MVP Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Wed, 26 Nov 2008 06:55:00 -0800, Teddy-B wrote: I have column with strings of text that has the # symbol in front. #1234567891011 I need to remove the # symbol. Text to columns does not work with (fixed with). Thanks: Teddy-B |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SYMBOL ¦please help how do i do this symbol without copy/pasting i | Excel Worksheet Functions | |||
How to remove the % symbol only | Excel Discussion (Misc queries) | |||
How can I remove the % symbol from a cell. Thanks | Excel Discussion (Misc queries) | |||
remove percent symbol on percentage formatted cells in excel | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |