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