Barryj
12-01-2011, 10:16 PM
I import data from another source which then gets sent to another sheet for printing, lately the source info has changed slighty and I am wondering if someone could help provide a solution.
Curently I use a find and replace macro to tidy up any little problems, but this is not solving this issue.
Previously the data looked like this:
1373
1372
1385
1368
Now the data coming in looks like this:
1373T
1372T
1385T
1368T
The problem with using the current find and replace macro is that there is other data in the column with words that have a T in them.
What I'm looking for is a solution that only removes the T if it is behind a number and not in a word.
Selection.Replace What:="NTA", Replacement:="OFF", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
If I use the above find and replace solution I lose the T out of words that contain a T.
I hope this make sense and appreciate any help.
Curently I use a find and replace macro to tidy up any little problems, but this is not solving this issue.
Previously the data looked like this:
1373
1372
1385
1368
Now the data coming in looks like this:
1373T
1372T
1385T
1368T
The problem with using the current find and replace macro is that there is other data in the column with words that have a T in them.
What I'm looking for is a solution that only removes the T if it is behind a number and not in a word.
Selection.Replace What:="NTA", Replacement:="OFF", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
If I use the above find and replace solution I lose the T out of words that contain a T.
I hope this make sense and appreciate any help.