They get deleted of course.
I really must take a reading comprehension course.<g
Can't use old age excuse for everything.
--
Regards,
RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------
"Dave Peterson" wrote in message
...
What happens to the leading two characters IF the value don't start with 23
(or
49)?
Ragdyer wrote:
if?
... Waiting for that second shoe to drop!<g
--
Regards,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Don Guillett" wrote in message
...
if?
--
Don Guillett
SalesAid Software
"Ragdyer" wrote in message
...
Select the column, then,
<Data <Text To Columns
Click on "Fixed Width", then <Next,
Click in the "Preview Window" and place the 'break line' to separate
the
first 2 numbers from the rest.
Then <Next
This first column (2 numbers) is selected by default.
Click on "Do Not Import"
The column header changes to "Skip"
NOW, some choices!
Click in the second column to select it.
The header says "General" (for format type).
You can change that to text if you wish by clicking on "Text", or just
leave
it as General
You now have the choice of *changing (deleting)* the original column
and
replacing it with this new configuration (eliminating the first 2
numbers),
OR
Preserving the original column and insert this newly configured column
elsewhere.
To *replace* the old with the new, click <Finish
To *retain* the old, click in the "Destination" box, and change the
default
location (original column location), to some other vacant column of
your
choice, *then* click <Finish.
--
HTH,
RD
--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may
benefit
!
--------------------------------------------------------------------------
-
"se12" wrote in message
...
In a column of numbers, SOME cell of numbers START WITH "23", I need
to
delete the first two numbers (23) only and leave the rest of the
numbers
in
that cell as they appear. A Column can have up to 600 cells. Also,
the
numbers are Imported into Excel as TEXT Format. Can you help
me...Thank
You!!
Example: 231234567890 (Numbers Imported into Excel as TEXT Format)
Need To Look Like This: 1234567890
--
Dave Peterson