Cell contents Prefixing

H

HockeyFan

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?
 
C

CLR

Assuming your date is in column A. One way would be to use a helper column
and this formula copied down....then do Copy > PasteSpecial > Values on the
helper column to get rid of the formulas and replace column A with the helper
column........

=IF(LEFT(A1,1)="Q",A1,"Q"&A1)

Vaya con Dios,
Chuck, CABGx3
 
Top