Hi guys,
I've attached a sample file from which i want to remove the preceding numbers, spaces and hyphens from the values in col F (highlighted in yellow).
Can't find any way at all of doing it in Excel .
Thanks guys!
Z
Hi guys,
I've attached a sample file from which i want to remove the preceding numbers, spaces and hyphens from the values in col F (highlighted in yellow).
Can't find any way at all of doing it in Excel .
Thanks guys!
Z
This formula should do:
=MID(TRIM(F2), FIND(" ", TRIM(F2), FIND(" ", TRIM(F2))+1)+1,256)
Hi,
I wondered if you could help me evolve the VB script in the attached file so that it ALSO removes "_" (underscores), "-" (hyphens) and spaces from cell values?
Script is:
Please Login or Register to view this content.
Last edited by zudecke; 03-21-2018 at 08:17 AM.
It is over my head, but maybe someone will be more helpful. But that is a function and it will do the same thing as my formula(except that is not working yet).
Worked it out through a couple trial and errors:
If anyone's interested!Please Login or Register to view this content.
Thanks all!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks