| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Convert text string to IP address
On Mon, 21 Sep 2009 15:53:01 -0700, Mike
wrote: I've got a bunch of text strings similar to this one: 064190119066. Is there a way to convert this into an IP address in Excel? Thanks! Here's one way: =TEXT(A1,"000\.000\.000\.000") --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cannot convert text string into value | Excel Worksheet Functions | |||
| Convert numbers to text string | Excel Discussion (Misc queries) | |||
| return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
| Convert text string to date | Excel Worksheet Functions | |||
| How can I convert text to reference ? Ex: ISNUMBER(ADDRESS(6;10;2. | Excel Discussion (Misc queries) | |||
Threaded Mode
