HatchetHarry
New Member
- Joined
- Aug 20, 2018
- Messages
- 16
- Office Version
- 365
Hello guys !
I try to find a way to remove "#" if the next character is alphabetic and do nothing if it's a "number".
For example :
#Blue = Blue
#5 Green = #5 Green
I came up with something but it has no effect :
File here https://we.tl/t-y9ooeyp16l
I want to precise that all the data are string including numbers (from a previous code) that's why "not isNumeric" wouldn't work.
If someone has a clue...
Thank you very much,
Harry
I try to find a way to remove "#" if the next character is alphabetic and do nothing if it's a "number".
For example :
#Blue = Blue
#5 Green = #5 Green
I came up with something but it has no effect :
Code:
For i = 2 To 300
If Mid(Cells(i, 8), 2) = "[a-zA-Z]*" Then Cells(i, 8) = Replace(Cells(i, 8), "#", "")
End If
File here https://we.tl/t-y9ooeyp16l
I want to precise that all the data are string including numbers (from a previous code) that's why "not isNumeric" wouldn't work.
If someone has a clue...
Thank you very much,
Harry