![]() |
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. |
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. |
All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com