| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| capitalize first letter automatically when typing in excel cell | Excel Discussion (Misc queries) | |||
| Excel= can I count how many times letter a appears in 1 cell? | Excel Worksheet Functions | |||
| How do I get a number or letter to represent cell contents? | Excel Discussion (Misc queries) | |||
| Last letter in Excel cell is truncated when printed. | Excel Discussion (Misc queries) | |||
| Merging excel contents to a Word Letter | Excel Programming | |||
Linear Mode
