-
If you would like to post, please check out the MrExcel Message Board FAQ and click here to register.
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
- 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
- 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
- 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
- Replies: 5
- Forum: Excel Questions
Some videos you may like
This Week's Hot Topics
-
Help with summation of different rows in 1 column
- Started by bassemjohn1
- Replies: 30
[B]Hello guys, [/B] I am new here and am in need of your help,I have a report that is really taking a huge time and all I need is a [B]way to sum... -
Excel VBA Code to Compare Rows in Two Different Sheets and Highlight Only the Cells that are different/unique
- Started by Walkerwood9
- Replies: 25
I have a workbook that has two sheets in it and I want to compare these sheets (Test1 and Test 2) and highlight only the individual cells that are... -
COUNTIFS function help please
- Started by andrewmurray86
- Replies: 25
Hi all, This is my first post here: I'm attempting to identify the smallest number within a column. I have a series of sheets with a column... -
Move row automatically to the bottom of the sheet when cell changes
- Started by CindyLou
- Replies: 23
I have a column of "Open" and "Closed" items. When the cell is changed to "Closed," I'm trying to get the whole row to go to the bottom of the... -
Change date format on import
- Started by namloop
- Replies: 37
Good morning I am importing some data and I am having two different issues in col. B. In rows 3 this data says Nov-9 (the 9th of November) when I... -
Problem with macro
- Started by Jeeremy7
- Replies: 20
Hello, I have a macro running but i think some informations are in double so the macro doesn't work.. If somoene could help it would be really...