hi all
i am looking for your kind help in formula or vb code to do the following
i have two columns one of them has an employees numbers every number in every cell and the other column has in every cell a text and date and one number from the numbers of the the other column >
what i need is to but the beside every cell the employee number in third column ?
i tried to make vlooup formula but it doesn't work because it can not search about numbers inside text >
i tried to remove all text character and keep only digits but because cells has dates too i couldn't separate the employee numbers .
your help is really appreciated
Bookmarks