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!

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!

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!