Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prefixing a cell?
I have a simple question.
I have a column in a spreadsheet where some rows start with the letter Q, and some do not. I'd like to update the rows so that column is prefixed with the letter Q on every row. Is there a way to do this? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
prefixing a cell?
Sub AddQ()
Dim i As Long For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row If Cells(i,"A").Value < "" Then If Left(Cells(i,"A").Value,1) < "Q" Then Cells(i,"A").value = "Q" & Cells(i,"A").value End If End If Next i End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "HockeyFan" wrote in message ups.com... I have a simple question. I have a column in a spreadsheet where some rows start with the letter Q, and some do not. I'd like to update the rows so that column is prefixed with the letter Q on every row. Is there a way to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prefixing a number to the number in a cell | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Merging 2 cells together and prefixing | Excel Worksheet Functions | |||
Prefixing a selection of cells with zeros | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |