Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert same word into selected column
We need to insert same word in front each verb in selected columns. I
appreciate if anyone help me. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I insert same word into selected column
Use a helper column. In row 1 of a free column type =CONCATENATE("Prefix
",A1) This will give you Prefix verb in the new cell. Copy the cell down as far as required. Select the new column, copy then paste specialvalues over the original data. I've assumed your data starts at A1, but adjust the reference to suit. -- Ian -- "ZigZig" wrote in message ... We need to insert same word in front each verb in selected columns. I appreciate if anyone help me. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) | |||
getting value 1 column to right of cell selected in pulldown | Excel Worksheet Functions | |||
Insert excel data source into word doc using currency symbols | Excel Worksheet Functions | |||
insert column without changing references | Excel Worksheet Functions |