I have a problem I am not sure how to solve. Until now I have been
doing this process row by row myself.

One column of my datatable contains Purchase Orders Numbers prior to
the purchased item list. The PO#'s always begin with Y851and can be
upwards of 20 digits beyond that (ex. Y8518945 or Y85199753532453564356
both are valid PO#'s that could arise etc.) There is always a space
separating the PO# from the item list. What I am in need of is a macro
that will delete the PO#'s from each row if I were to select the entire
column, but that would leave the item list following the PO# untouched.

Any help would be greatly appreciated.

Thanks