Add a mark in every row in a column

[Mike]

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

 

[Lars-Åke Aspelin]

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

 

[Gaurav]

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]

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?

 

[Mike]

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]

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

 

[Mike]

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

 

[Mike]

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]

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]

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

 

[Mike]

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"

 

[Mike]

got it to work

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

 

[Lars-Åke Aspelin]

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