cleaning up strings in table cells

[De Vo]

I currently working on first applied vba application

basically involving calculation and validation in a table

i have ran in to this problem I pass the text in employee name to a
string using .cell(x,y).range.text

but when I validate it and alter the string in my code or format the
existing valid string it screws up when I put back in the same cell
(bascially replacing itself)

it looks like it places extra character and enter an extra a soft
carridge return in when its placed which then seems to throw out the
rest of the rows cells.

The routine is basically count that as row inbalance move on to the
next column but move to the above row.

can some one give me a guide of how to cure this...
or what command I can use to ensure clean content is put back in to the
cell in question

hope this makes sense and not a load of gibberish

regards

de vo

 

[De Vo]

De Vo wrote:

good news and bad news,

found how to do it with Left$(strEmployeesName, Len(strEmployeesName) -
2)

but the prob was something to do with a little bit of validation coding
that was confusing the issue and buggering up my row calcs..

anyway posted this just in case someone needs to know