Pls help with valid code. Thanks

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I have a xl sheet which contains junk values and required values in mixed format

I need to separate the required values alone and put them in separate sheet under a table format

consider,

Sheet 1 contains junk values like, (everything in cell like (1,1) (2,1) (3,1)

row 1- NOWBS BJSDD ADSD\QA\QAAAA\SDSDD\&&asassss\50541 proj name
row 2 - FGFGgJLKJJKJH\Qa\QAAA\GSfgsgsgsgsg\&&zzzzzzz\64482 proj name

I have to separate the 5 digits project number alone ie(64482 and 50541) and place it separately in another sheet in a table format

Can anyone pls come back with a code and steps

Thans in advance


1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use a formula to find the location of the last "\" and then put every thing after that on a new cell