Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit many cells at once to add a charater to existing data?
I have a column of data and I need to add an apostrophe to the beginning of
all the cells without changing the remaining content. How can I do this? I know how to do this for individual cells, but I would like to do it to all cells at once. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit many cells at once to add a charater to existing data?
The easiest way is to write a formula in a new column. then copy the results
from the new column back to the old column and use PastSpecial with values selected. the formula to use in the new column would be this. ="'" & A1 This is a double quote, then an apostrophe, and then another double quote Copy the formula down the column. "ABTurner" wrote: I have a column of data and I need to add an apostrophe to the beginning of all the cells without changing the remaining content. How can I do this? I know how to do this for individual cells, but I would like to do it to all cells at once. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit many cells at once to add a charater to existing data?
Select the cells and run this small macro:
Sub DontQuoteMe() Dim q As String q = Chr(39) For Each r In Selection r.Value = q & q & r.Value Next End Sub Note you need to add the single quote twice to get it to appear in the cell as well as the formula bar. -- Gary''s Student - gsnu200838 "ABTurner" wrote: I have a column of data and I need to add an apostrophe to the beginning of all the cells without changing the remaining content. How can I do this? I know how to do this for individual cells, but I would like to do it to all cells at once. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Edit many cells at once to add a charater to existing data?
Helper column ="'"&A1 and copy down. The copy this column, & Edit/ Paste
Special/ Values over the original data and delete the helper column. -- David Biddulph "ABTurner" wrote in message ... I have a column of data and I need to add an apostrophe to the beginning of all the cells without changing the remaining content. How can I do this? I know how to do this for individual cells, but I would like to do it to all cells at once. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shortening pre-existing data in cells in a particular column | Excel Discussion (Misc queries) | |||
How to change data in cells of an existing saved form- | Excel Discussion (Misc queries) | |||
Make Existing Data In Cells Text | Excel Worksheet Functions | |||
List created from XML Data, how to shift existing cells down? | Excel Discussion (Misc queries) | |||
HOW DO I EDIT AN EXISTING FILE TO BE SPACE DELIMITED? | Excel Discussion (Misc queries) |