-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
convert text string
-
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...- mickeb
- Thread
- convert text string group id
- Replies: 6
- Forum: Excel Questions
-
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- mdd16
- Thread
- convert text string
- Replies: 4
- Forum: Excel Questions
-
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...- Rocky0201
- Thread
- convert text string
- Replies: 5
- Forum: Excel Questions
-
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...- jimsjams
- Thread
- convert text string time
- Replies: 5
- Forum: Excel Questions
Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.
