software

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: www.excelforum.com/member.php...foamp;userid=8238
View this thread: www.excelforum.com/showthread...hreadid=532749Thats easy, clear out several columns to the right of the column, go to
data-texttocolumns- then select delimited and use the quot;-quot; as the value. You
will then have three columns xxxx then xxxxxxxx then xxxxx. Then you can
delete the two unneeded columns.

quot;Aversinquot; wrote:

gt;
gt; I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx
gt; 4numbers - 7 numbers - 4numbers
gt;
gt; What I need to do is to remove the first 4 and last 4 numbers and the
gt; dash with them.
gt;
gt; Any ideas.
gt;
gt;
gt; --
gt; Aversin
gt; ------------------------------------------------------------------------
gt; Aversin's Profile: www.excelforum.com/member.php...foamp;userid=8238
gt; View this thread: www.excelforum.com/showthread...hreadid=532749
gt;
gt;


Thanks!!!!!!!!!

You Rock --
Aversin
------------------------------------------------------------------------
Aversin's Profile: www.excelforum.com/member.php...foamp;userid=8238
View this thread: www.excelforum.com/showthread...hreadid=532749Applys 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?quot;Aversinquot; wrote:

gt;
gt; I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx
gt; 4numbers - 7 numbers - 4numbers
gt;
gt; What I need to do is to remove the first 4 and last 4 numbers and the
gt; dash with them.
gt;
gt; Any ideas.
gt;
gt;
gt; --
gt; Aversin
gt; ------------------------------------------------------------------------
gt; Aversin's Profile: www.excelforum.com/member.php...foamp;userid=8238
gt; View this thread: www.excelforum.com/showthread...hreadid=532749
gt;
gt;

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?quot;Aversinquot; wrote:

gt;
gt; Thanks!!!!!!!!!
gt;
gt; You Rock
gt;
gt;
gt; --
gt; Aversin
gt; ------------------------------------------------------------------------
gt; Aversin's Profile: www.excelforum.com/member.php...foamp;userid=8238
gt; View this thread: www.excelforum.com/showthread...hreadid=532749
gt;
gt;

Easier yet................At Step 3 of T to C, choose to quot;do not import this
column(skip)quot;

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
gt; wrote:

gt;Thats easy, clear out several columns to the right of the column, go to
gt;data-texttocolumns- then select delimited and use the quot;-quot; as the value. You
gt;will then have three columns xxxx then xxxxxxxx then xxxxx. Then you can
gt;delete the two unneeded columns.
gt;
gt;quot;Aversinquot; wrote:
gt;
gt;gt;
gt;gt; I have a colom of numbers all in the same format xxxx-xxxxxxx-xxxx
gt;gt; 4numbers - 7 numbers - 4numbers
gt;gt;
gt;gt; What I need to do is to remove the first 4 and last 4 numbers and the
gt;gt; dash with them.
gt;gt;
gt;gt; Any ideas.
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Aversin
gt;gt; ------------------------------------------------------------------------
gt;gt; Aversin's Profile: www.excelforum.com/member.php...foamp;userid=8238
gt;gt; View this thread: www.excelforum.com/showthread...hreadid=532749
gt;gt;
gt;gt;