replace part of cells

Posted by Lisa Hein on January 25, 2001 2:19 AM

i have a column with various text and want to add in each cell the same additional text. how may i do this ?

for exsample: text before changing is "m123"
the new text should be "m123-update"

Posted by Dave Hawley on January 25, 2001 3:49 AM

Hi Lisa

Let's say your text "m123" is in cell A1 and "update" is in cell B1.

In any cell put =A1&"-"&B1

....Or =CONCATENATE(A1,"-",B1)

Or if "update" is not in any cell then

=A1&"-update"

Hope this helps

Dave

OzGrid Business Applications