Add Same in each cell in column
I am trying to add the same words to the beginning of each cell in a column
like for example the following ""abc.com/catalog/" to the beginning of the cell. Sol |
Add Same in each cell in column
Say we have data in column A from A1 thru A100. Say the data is text and not
formulas. In B1 enter: ="abc.com/catalog/" & A1 and copy down then copy column B and paste/special/values back onto column A then clear column B If column A contains formulas, the approach is much simplier. Using Find/Replace, replace: = with ="abc.com/catalog/" & -- Gary''s Student - gsnu200908 "S1L1Y1" wrote: I am trying to add the same words to the beginning of each cell in a column like for example the following ""abc.com/catalog/" to the beginning of the cell. Sol . |
All times are GMT +1. The time now is 09:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com