convert text string

  1. M

    Assign uniqiue Group ID for each groupname (not using case/if)

    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...
  2. M

    Convert Text to number

    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
  3. R

    Simple Convert Question

    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...
  4. J

    Convert text string to time?

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top