PC Review


Reply
Thread Tools Rate Thread

add a letter to contents in a cell in excel

 
 
=?Utf-8?B?U2FtbXk=?=
Guest
Posts: n/a
 
      24th Jan 2007
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 With Quote
 
 
 
 
=?Utf-8?B?aWN5?=
Guest
Posts: n/a
 
      24th Jan 2007
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.

 
Reply With Quote
 
Chip Pearson
Guest
Posts: n/a
 
      24th Jan 2007
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
news76968B1-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.



 
Reply With Quote
 
=?Utf-8?B?U2FtbXk=?=
Guest
Posts: n/a
 
      24th Jan 2007
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
> news76968B1-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.

>
>
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:53 PM.