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