| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing out numbers in a cell
I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx 4numbers - 7 numbers - 4numbers What I need to do is to remove the first 4 and last 4 numbers and the dash with them. Any ideas. -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing out numbers in a cell
Thats easy, clear out several columns to the right of the column, go to
data-texttocolumns- then select delimited and use the "-" as the value. You will then have three columns xxxx then xxxxxxxx then xxxxx. Then you can delete the two unneeded columns. ;) "Aversin" wrote: I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx 4numbers - 7 numbers - 4numbers What I need to do is to remove the first 4 and last 4 numbers and the dash with them. Any ideas. -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing out numbers in a cell
Easier yet................At Step 3 of T to C, choose to "do not import this
column(skip)" You will not have to deal with the two unwanted columns. Gord Dibben MS Excel MVP On Thu, 13 Apr 2006 12:46:01 -0700, karmaisgreat wrote: Thats easy, clear out several columns to the right of the column, go to data-texttocolumns- then select delimited and use the "-" as the value. You will then have three columns xxxx then xxxxxxxx then xxxxx. Then you can delete the two unneeded columns. ;) "Aversin" wrote: I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx 4numbers - 7 numbers - 4numbers What I need to do is to remove the first 4 and last 4 numbers and the dash with them. Any ideas. -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing out numbers in a cell
Thanks!!!!!!!!! You Rock :) -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing out numbers in a cell
Who rocks!!?;) Me or Karma.. Actually, it would be great for both of us if
you rated our posts so that we knew which solution worked for you, even if they both did! Thanks Aversin! -- Hope this Helps! Camilo Objective: To help one person each day! Feedback is greatly appreciated! Please let me know if I've answered your question or if my post was helpful to you? "Aversin" wrote: Thanks!!!!!!!!! You Rock :) -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Editing out numbers in a cell
Applys to the format you mentioned (ie. xxxx-xxxxxxx-xxxx)
=MID(A1,6,7) -- Hope this Helps! Camilo Objective: To help one person each day! Feedback is greatly appreciated! Please let me know if I've answered your question or if my post was helpful to you? "Aversin" wrote: I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx 4numbers - 7 numbers - 4numbers What I need to do is to remove the first 4 and last 4 numbers and the dash with them. Any ideas. -- Aversin ------------------------------------------------------------------------ Aversin's Profile: http://www.excelforum.com/member.php...fo&userid=8238 View this thread: http://www.excelforum.com/showthread...hreadid=532749 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| separating numbers and letters from alphanumeric cell contents | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Cell will not format numbers correctly for a 13 digit custom barc. | Excel Worksheet Functions | |||
| create a cell that accumulates, numbers from another cell... | Excel Discussion (Misc queries) | |||
Hybrid Mode
