kmeunier
New Member
- Joined
- Oct 2, 2006
- Messages
- 24
I have a column of data that has a product number within each cell. The product # contains at least one hyphen, but possibly more. My goal is to locate the last hyphen in each cell and break the data into two parts. Everything after the last hyphen (including the hyphen) should be moved to a cell in a newly created column on the right.
Example of valid products codes:
Column1
123-EA1
BGF33201-R-GR-BX10
How can I do this so that I end up with
123 in column1 and -EA1 in column2
and
BGF33201-R-GR in column1 and -BX10 in column2?
Thank you in advance for any suggestions you can provide me!
Kathy M. - Richmond, VA
Example of valid products codes:
Column1
123-EA1
BGF33201-R-GR-BX10
How can I do this so that I end up with
123 in column1 and -EA1 in column2
and
BGF33201-R-GR in column1 and -BX10 in column2?
Thank you in advance for any suggestions you can provide me!
Kathy M. - Richmond, VA