Add a mark in every row in a column
 

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually

Add a mark in every row in a column
 

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Åke

Add a mark in every row in a column
 

Assuming your data is in Column A starting at Row 1.

in B1, enter the following.

=","&" "&A1

and drag it down as far as needed. once done, you can also copy the entire
column B | Go to A1 | Right Click | Paste Special | Values | Delete Column
B.

Add a mark in every row in a column
 

I tried it but it didnt work, maybe i did something wrong with the formula or
something. I need to use this formula on column H, row 9-7140. those are the
ones i need the ", " in I need to keep the information thats in the row as
you've written in the formula but as i said it didn't work :/ and what
happens if i've used a filster so it only shows 4000 rows out of 7000?

"Gaurav" wrote:

Assuming your data is in Column A starting at Row 1.

in B1, enter the following.

=","&" "&A1

and drag it down as far as needed. once done, you can also copy the entire
column B | Go to A1 | Right Click | Paste Special | Values | Delete Column
B.

Hope that helps.


"Mike" wrote in message
...
Hi, I need to add "," and a space in the beginning of every row in a
column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this
automaticly
instead of doing it all manually

Add a mark in every row in a column
 

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Ã…ke

Add a mark in every row in a column
 

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Åke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Åke

Add a mark in every row in a column
 

Now i understood what you ment :D got it to work! brilliant :D

"Mike" wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually

Add a mark in every row in a column
 

Ok, i''ve succesfully copied all the rowes with a ", " but now what, how to
save the copied and finished text to a "real" text or what you call it, and
get rid of the formula?

"Mike" wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually

Add a mark in every row in a column
 

yes, i managed to do that now. but one problem still exists. now i got 2 rows
with the same information except that 1 row with ", " infront of it and the
other without. and if i try to delete the first row the second row which
still got the formula in it changes too, so how to get rid of the formula
without making the text dissapear?

"Lars-Ã…ke Aspelin" wrote:

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Ã…ke

Add a mark in every row in a column
 

Take another look at my answer below. It is right there.
(Look for the words "Paste special")


On Tue, 22 Jul 2008 04:12:00 -0700, Mike
wrote:

yes, i managed to do that now. but one problem still exists. now i got 2 rows
with the same information except that 1 row with ", " infront of it and the
other without. and if i try to delete the first row the second row which
still got the formula in it changes too, so how to get rid of the formula
without making the text dissapear?

"Lars-Åke Aspelin" wrote:

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Åke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Åke

Add a mark in every row in a column
 

Well, that would work if i hadn't used filter becuase because of some strange
reason it skips som rows when some rows then the between has been removed
because of the filter. What works is if I cut it out, but i cant copy becuase
then it posts like 4 rows out of 20, and if i cut it out i cant use "paste
special"

"Lars-Ã…ke Aspelin" wrote:

Take another look at my answer below. It is right there.
(Look for the words "Paste special")


On Tue, 22 Jul 2008 04:12:00 -0700, Mike
wrote:

yes, i managed to do that now. but one problem still exists. now i got 2 rows
with the same information except that 1 row with ", " infront of it and the
other without. and if i try to delete the first row the second row which
still got the formula in it changes too, so how to get rid of the formula
without making the text dissapear?

"Lars-Ã…ke Aspelin" wrote:

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Ã…ke

Add a mark in every row in a column
 

got it to work

"Lars-Ã…ke Aspelin" wrote:

Take another look at my answer below. It is right there.
(Look for the words "Paste special")


On Tue, 22 Jul 2008 04:12:00 -0700, Mike
wrote:

yes, i managed to do that now. but one problem still exists. now i got 2 rows
with the same information except that 1 row with ", " infront of it and the
other without. and if i try to delete the first row the second row which
still got the formula in it changes too, so how to get rid of the formula
without making the text dissapear?

"Lars-Ã…ke Aspelin" wrote:

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Ã…ke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Ã…ke

Add a mark in every row in a column
 

Could you temporarily remove the filter and then put it back once the
copying of the column has been done?


On Tue, 22 Jul 2008 04:31:02 -0700, Mike
wrote:

Well, that would work if i hadn't used filter becuase because of some strange
reason it skips som rows when some rows then the between has been removed
because of the filter. What works is if I cut it out, but i cant copy becuase
then it posts like 4 rows out of 20, and if i cut it out i cant use "paste
special"

"Lars-Åke Aspelin" wrote:

Take another look at my answer below. It is right there.
(Look for the words "Paste special")


On Tue, 22 Jul 2008 04:12:00 -0700, Mike
wrote:

yes, i managed to do that now. but one problem still exists. now i got 2 rows
with the same information except that 1 row with ", " infront of it and the
other without. and if i try to delete the first row the second row which
still got the formula in it changes too, so how to get rid of the formula
without making the text dissapear?

"Lars-Åke Aspelin" wrote:

You should not "try it on many rows" that way.

Just enter
=", "&H3 in cell x3 (where x represents any spare column)

then "drag" this formula down until the last row of your data



On Tue, 22 Jul 2008 03:42:07 -0700, Mike
wrote:

I'm able to use the formula =", "&H3 on one row but if i try it on many rows
like =", "&H3:H6 it doesn't work

"Lars-Åke Aspelin" wrote:

On Tue, 22 Jul 2008 01:50:01 -0700, Mike
wrote:

Hi, I need to add "," and a space in the beginning of every row in a column.
so it looks like ", " in the beginning of the row. I've got 4000 rows so I
would prefer if someone could help me do something that does this automaticly
instead of doing it all manually


Do you want to add another (leftmost) column?
Or do you want to modify the content of the cells in the leftmost
column (that is column A)?

In the first place, just insert a new column, put ", " in cell A1 and
fill down to cover all 4000 rows.

In the other place, do the cells in column A hold any formulas or are
there just constants?

If there are just constants you can insert a new column A and then put
the following formula in cell A1:

=", "&B1

Copy this down the 400 rows

Copy the entire column A and paste it with "Paste Special" (where you
select the Values option) onto column B.
FInally you can remove column A.

If there are formulas in your leftmost column I don't know any simple
way of adding the ", " to the beginning of the data without modifying
each of these formulas.

Hope this helps / Lars-Åke