Gerhardpet
asked on
Remove data from Excel cell
I have the attached an excel file where I have data like this AS-P31-111 25 00
Up to the first 3 spaces it is the SKU"AS-P31-111" and I want to remove everything starting at the 3 spaces
Can someone help with the formula to do this?
sample.xlsx
Up to the first 3 spaces it is the SKU"AS-P31-111" and I want to remove everything starting at the 3 spaces
Can someone help with the formula to do this?
sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That worked! Thanks for the help!
Thanks
Rob H