Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Contents of a cell.
Ok, So i have a few columns of data with about 1600 rows or so per column
The data in the rows looks like what is shown below. The numbers in the rows are stored as text. Here is what i need to do, I need the first number ONLY, and not the percentage. So basically i need to turn every cell into the number that appears first in every cell, and then delete the parentheses and percentages. Anyone have any easy way to do this? 3 (8%) 4 (12%) 0 (0%) 8 (15%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 7 (5%) 6 (3%) 10 (4%) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Contents of a cell.
Without VBA, use Text to Columns with the space as a separator.
With VBA, select the cells and run: Sub numberr() For Each r In Selection r.Value = Split(r.Value, " ")(0) Next End Sub -- Gary''s Student - gsnu200770 "Adam" wrote: Ok, So i have a few columns of data with about 1600 rows or so per column The data in the rows looks like what is shown below. The numbers in the rows are stored as text. Here is what i need to do, I need the first number ONLY, and not the percentage. So basically i need to turn every cell into the number that appears first in every cell, and then delete the parentheses and percentages. Anyone have any easy way to do this? 3 (8%) 4 (12%) 0 (0%) 8 (15%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 7 (5%) 6 (3%) 10 (4%) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Contents of a cell.
Hey Thanks for the help,
Can you walk me through doing the without VBA method. THanks, -ADam "Gary''s Student" wrote: Without VBA, use Text to Columns with the space as a separator. With VBA, select the cells and run: Sub numberr() For Each r In Selection r.Value = Split(r.Value, " ")(0) Next End Sub -- Gary''s Student - gsnu200770 "Adam" wrote: Ok, So i have a few columns of data with about 1600 rows or so per column The data in the rows looks like what is shown below. The numbers in the rows are stored as text. Here is what i need to do, I need the first number ONLY, and not the percentage. So basically i need to turn every cell into the number that appears first in every cell, and then delete the parentheses and percentages. Anyone have any easy way to do this? 3 (8%) 4 (12%) 0 (0%) 8 (15%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 7 (5%) 6 (3%) 10 (4%) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Contents of a cell.
Select the column and pull-down:
Data Text to Columns... Delimited Next check space clear tab Next click first column General click next column do not import Finish -- Gary''s Student - gsnu200770 "Adam" wrote: Hey Thanks for the help, Can you walk me through doing the without VBA method. THanks, -ADam "Gary''s Student" wrote: Without VBA, use Text to Columns with the space as a separator. With VBA, select the cells and run: Sub numberr() For Each r In Selection r.Value = Split(r.Value, " ")(0) Next End Sub -- Gary''s Student - gsnu200770 "Adam" wrote: Ok, So i have a few columns of data with about 1600 rows or so per column The data in the rows looks like what is shown below. The numbers in the rows are stored as text. Here is what i need to do, I need the first number ONLY, and not the percentage. So basically i need to turn every cell into the number that appears first in every cell, and then delete the parentheses and percentages. Anyone have any easy way to do this? 3 (8%) 4 (12%) 0 (0%) 8 (15%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 7 (5%) 6 (3%) 10 (4%) |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Contents of a cell.
NM, Figured it out,
Thanks again "Adam" wrote: Hey Thanks for the help, Can you walk me through doing the without VBA method. THanks, -ADam "Gary''s Student" wrote: Without VBA, use Text to Columns with the space as a separator. With VBA, select the cells and run: Sub numberr() For Each r In Selection r.Value = Split(r.Value, " ")(0) Next End Sub -- Gary''s Student - gsnu200770 "Adam" wrote: Ok, So i have a few columns of data with about 1600 rows or so per column The data in the rows looks like what is shown below. The numbers in the rows are stored as text. Here is what i need to do, I need the first number ONLY, and not the percentage. So basically i need to turn every cell into the number that appears first in every cell, and then delete the parentheses and percentages. Anyone have any easy way to do this? 3 (8%) 4 (12%) 0 (0%) 8 (15%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 0 (0%) 7 (5%) 6 (3%) 10 (4%) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing Length of Cell Contents | Excel Discussion (Misc queries) | |||
Changing cell contents | Excel Discussion (Misc queries) | |||
Changing Cell Contents Colour | Excel Discussion (Misc queries) | |||
Changing the Contents of a Cell | Excel Discussion (Misc queries) | |||
Changing the contents of a cell... dynamically? | Excel Programming |