excel macro

[raj00]

Hi

How can I delete a character from a cell in excel sheet using macro? For Example if i have value like #45675 and I want to delete just # sign how can I write macro so that it will take out # sign from each cell.


Thanks
Raj

 

[amm9290]

This will work. Add this code to a module.
Select the range of cells you want the char removed from.
Then run this routine.

Sub Remove()

char = InputBox("Enter char to replace&quot
For Each c In Selection
c.Replace what:=char, replacement:=""
Next c

End Sub

AMM9290

 

[xlbo]

Or, if the # is at the fron of all cells, use a formula:
=right(A1,len(a1)-1)
HTH
Geoff