Remove # Symbol

  • Thread starter Thread starter Teddy-B
  • Start date Start date
T

Teddy-B

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
 
Same deal, use "Edit", "Replace" (and leave Replace with blank)

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott
 
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)
 
Back
Top