| Home | Forums | Reviews | Articles | Register |
 |
| Thread Tools | Rate Thread |
|
Guest
Posts: n/a
|
|
|
|
||
|
|
| |
|
Guest
Posts: n/a
|
|
|
|
|
||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message news  76968B1-2055-4F96-8E05-(E-Mail Removed)...>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. |
|
|
|
|
|||
|
Guest
Posts: n/a
|
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" <(E-Mail Removed)> wrote in message > news 76968B1-2055-4F96-8E05-(E-Mail Removed)...> >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. > > > |
|
|
|
|
|||
|
|
| |
|
| Thread Tools | |
| Rate This Thread | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Can Excel recognise cell contents as a cell reference | sincln21 | Microsoft Excel Misc | 2 | 25th Feb 2009 02:31 PM |
| Excel:Swap cell contents-including cell groups-betwen 2 locations | Rob R | Microsoft Excel Misc | 0 | 6th Feb 2008 11:13 PM |
| How do I get a number or letter to represent cell contents? | =?Utf-8?B?Rm9ybXVsYSBoZWxw?= | Microsoft Excel Misc | 2 | 25th Feb 2006 11:51 PM |
| excel displays cell contents but won't print cell contents | =?Utf-8?B?RGpq?= | Microsoft Excel Crashes | 0 | 18th Nov 2005 01:56 AM |
| Merging excel contents to a Word Letter | Monica | Microsoft Excel Programming | 2 | 25th May 2004 09:33 PM |
