Home |
Search |
Today's Posts |
#4
![]() |
|||
|
|||
![]()
Select the range and run:
Sub AddSuffix() Dim cell As Range Application.ScreenUpdating = False For Each cell In Selection With cell If Not .HasFormula Then .Value = .Value & "scc" End If End With Next Application.ScreenUpdating = True End Sub --- HTH Jason Atlanta, GA -----Original Message----- I want to add the suffix "scc" into the contiguous cells of several columns on an existing Excel spreadsheet. There is existing data (alpha/numeric) in each of the cells already, so the scc suffix would be added to the right of the existing entries. I'm trying to avoid having to enter each suffix into each cell individually. I have Excel 2002 and Windows XP Professional. Thank you. . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking cells in Excel 2003. How to not truncate to 255 characters. | Excel Discussion (Misc queries) | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
How can I combine multiple cells in Excel? | Excel Discussion (Misc queries) | |||
background formatting across multiple cells | Excel Discussion (Misc queries) | |||
How do I extract cells from multiple workbooks | Excel Discussion (Misc queries) |