Hello i got a issue with converting groups in a dataset into numbers.. or maybe its called assign a group id.
So if example: (i have group name but not group ID)
Name Group Value GroupID
Flower 1 FlowerGroupX 400 1
Flower 2 FlowerGroupB 200 2
Flower 3 FlowerGroupA 500 3
Flower 4...
I want to convert a text to number.
Say if a cell contains "ABCD PRIVATE LIMITED"
I want get the first word converted to a predictable number.
Can someone help.
Mohan Dhingra
I have a string that has a cell reference such as "A1". I would like to retrieve the column number and put it into an integer. Is this possible?
Thanks...
Hi,
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p>
I’m trying to write a formula to convert a text string to a date readable by Excel.
<o:p> </o:p>
The times are currently in a format such as:
<o:p> </o:p>
<TABLE class=MsoNormalTable style="MARGIN: auto...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.