| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Appending Text
I have a range of 2,185 cells I need to add text to in front of the contents
of each of the cells. I've tried the Search/Replace feature, trying to use wildcards, but to no avail because it replaces the entire text. For instance, I tried this: Search for * and Replace with EBSCO:*. This put "EBSCO:*" in every cell, which is not what I want. I want "EBSCO:xxx", with xxx being the 3-letter code already there. Any advice would be greatly appreciated. Thank you! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Appending Text
-- John Hi, try using a formula in an adjacent range of cells. Example is the values you want to manipulate are in A1 to A2185 then insert the following formula in B1 and copy to the rest of the range. =CONCATENATE("EBSCO:",A1) Is this what you are looking for? John. "Jamen McGranahan" wrote: I have a range of 2,185 cells I need to add text to in front of the contents of each of the cells. I've tried the Search/Replace feature, trying to use wildcards, but to no avail because it replaces the entire text. For instance, I tried this: Search for * and Replace with EBSCO:*. This put "EBSCO:*" in every cell, which is not what I want. I want "EBSCO:xxx", with xxx being the 3-letter code already there. Any advice would be greatly appreciated. Thank you! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Appending Text
YES! That did it - thanks!
"asyado" wrote: -- John Hi, try using a formula in an adjacent range of cells. Example is the values you want to manipulate are in A1 to A2185 then insert the following formula in B1 and copy to the rest of the range. =CONCATENATE("EBSCO:",A1) Is this what you are looking for? John. "Jamen McGranahan" wrote: I have a range of 2,185 cells I need to add text to in front of the contents of each of the cells. I've tried the Search/Replace feature, trying to use wildcards, but to no avail because it replaces the entire text. For instance, I tried this: Search for * and Replace with EBSCO:*. This put "EBSCO:*" in every cell, which is not what I want. I want "EBSCO:xxx", with xxx being the 3-letter code already there. Any advice would be greatly appreciated. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy text from one workbook to another | Excel Discussion (Misc queries) | |||
| Shade cell according to text? | Excel Discussion (Misc queries) | |||
| Using Concatenate function to generate text in Text Box | Charts and Charting in Excel | |||
| Appending Text to a Cell Value | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Hybrid Mode
