wsom-itg
asked on
Hi, I have the following mixed data in a cell that I want to separate into two. I am looking for a solution with the best degree of automation possible here. Cell content is "1,234, 56.78%".
Button/Macro or using "=". Anything that may help automate this as much as possible. I want to split the data into two adjacent columns.
Kindly help.
Kindly help.
Click on the Data Ribbon, click Text to Columns, select Delimited and Next, check the box next to Comma, then Next, finish Wizard as needed.
ASKER
Great solution! Unfortunately, it also separates the 1,234 into 1 and 234.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yeah that helps. Thank you!
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.
With text to columns, you can use the space as the separator instead of comma.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER
Cell 1: 1,234
Cell 2: 56.78%
Note: The length of the number in Cell 1/2 may vary.