R
RISXRAY
Example...
1234-56789 becomes 56789
1234-56789 becomes 56789
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Toppers
Insert column to right of the column containing your data
Data==>Text-to-Columns=>Delimited=>Other ..enter "-" (no quotes) then Finish.
Delete redundant data i.e one containing the 4 digits.
HTH
Data==>Text-to-Columns=>Delimited=>Other ..enter "-" (no quotes) then Finish.
Delete redundant data i.e one containing the 4 digits.
HTH
R
RISXRAY
I formated the "-" in the cell by using custom formating (0000-00000), so
when I do the delimiting, it doesn't show the "-". My orginal number is
whole 123456789.
when I do the delimiting, it doesn't show the "-". My orginal number is
whole 123456789.
R
RISXRAY
Aha.... I removed the formating and did the conversion by a "fixed width".
Works great. Thank you for the lead...
Works great. Thank you for the lead...
P
Pete_UK
If your number is in A2, try this in a blank column:
=LEFT(A2,5)
which will return the values as text - if you want them as numbers, try
this:
=VALUE(LEFT(A2,5))
Copy the formula down for as many rows as you have data in column A.
Hope this helps.
Pete
=LEFT(A2,5)
which will return the values as text - if you want them as numbers, try
this:
=VALUE(LEFT(A2,5))
Copy the formula down for as many rows as you have data in column A.
Hope this helps.
Pete
P
Pete_UK
Sorry, you would need to use RIGHT rather than LEFT, but as you have
found another way to do it, it's irrelevant.
Pete
found another way to do it, it's irrelevant.
Pete