1. M

    Extracting numbers from a cell

    Is there any Excel formula (not VBA), that I can extract numbers from a cell? e.g. <tbody> B:271543GARDEN PL; 272512ESS H71 ;BT1 FLO QUAD 1 43170 345-ROCK CK3 345 (1). I want to see 271543 272512 71 1 1 43170 345 345 1 </tbody> Thank you
  2. K

    How to merge data together and combine data?

    <colgroup><col width="64" style="width: 48pt;"> <col width="316" style="width: 237pt; mso-width-source: userset; mso-width-alt: 11556;"> <col width="64" style="width: 48pt;" span="5"> <col width="127" style="width: 95pt; mso-width-source: userset; mso-width-alt: 4644;"> <col width="246"...
  3. M

    Decimal IP to Dotted Quad

    Hi Guys, I've got a list of IP addresses in a column in decimal format i.e. 168488278 and I want to convert them to Dotted Quad i.e. xxx.xxx.xxx.xxx There are far too many to do by hand and I can't figure it out so was wondering if you could give me some help? Thanks in advance

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...