add a letter to contents in a cell in excel
 

I have a spreadsheet with a lot of sku's in one of the columns. I would like
to add an R in front of these. I used a formula a few years ago to do this,
now I forget how I did it.

add a letter to contents in a cell in excel
 

use the excel function "CONCATENATE"

"Sammy" wrote:

I have a spreadsheet with a lot of sku's in one of the columns. I would like
to add an R in front of these. I used a formula a few years ago to do this,
now I forget how I did it.

add a letter to contents in a cell in excel
 

In a column, use a formula like

="R"&A1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Sammy" wrote in message
...
I have a spreadsheet with a lot of sku's in one of the columns. I would
like
to add an R in front of these. I used a formula a few years ago to do
this,
now I forget how I did it.

add a letter to contents in a cell in excel
 

That did it Chip, thanks much. Sammy.

"Chip Pearson" wrote:

In a column, use a formula like

="R"&A1


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Sammy" wrote in message
...
I have a spreadsheet with a lot of sku's in one of the columns. I would
like
to add an R in front of these. I used a formula a few years ago to do
this,
now I forget how I did it.