I have a 1000 line worksheet that I download from SAP, but the data is not
formatted correctly. I need to check if in Column H there is "ORD *" then
return that value a Column B. Going through every single line will take
forever. If somebody can help on this I would really appreciate it.
Column A Column H
300001846 0 7/1/2006
100108357 7/1/2006
ORD 14000732
100108357 7/1/2006
ORD 14000732

300001847 0 7/1/2006
100110756 7/1/2006
ORD 14000819
100110756 7/1/2006
ORD 14000819