Technology Questions

Go Back   Technology Questions > Software Questions > General Questions > Microsoft Office



Reply
 
LinkBack Thread Tools
  #1  
Old 10-23-2009, 08:30 AM
Susan
Newsgroup Contributor
 
Posts: n/a
Re: Add Same in each cell in column

you can always use a helper cell or two.
say your text is in column a
in column b, enter
="abc.com/catalog/" & a1
add spaces or whatever to make it like you want it.
then drag down b1 down the column as far as you need to go.
now highlight all of the cells in column b that say what you want.
copy it, and paste the values in column a.
delete column b.

hope that helps!
susan


On Oct 23, 11:24*am, "S1L1Y1" <s1l...******.com> wrote:
> I am trying to add the same words to the beginning of each cell in a column
> like for example the following ""abc.com/catalog/" to the beginning of the
> cell.
> Sol


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote

 
Old 10-23-2009, 08:30 AM
Reply

Bookmarks

Thread Tools

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 On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Add Same in each cell in column Gord Dibben Microsoft Office 0 10-23-2009 08:10 AM
Re: Add Same in each cell in column Bob I Microsoft Office 0 10-23-2009 08:00 AM
Re: Add Same in each cell in column Roger Govier Microsoft Office 0 10-23-2009 07:50 AM
Re: Add Same in each cell in column David Biddulph Microsoft Office 0 10-23-2009 07:50 AM
Re: Add Same in each cell in column Pete_UK Microsoft Office 0 10-23-2009 07:40 AM


New To Technology Questions? Do You Need Help with Your Computer or Device? Do You Need Help with this site?

All times are GMT -8. The time now is 06:54 AM.


2003 - 2010 All Rights Reserved. Technology Questions

Search Engine Friendly URLs by vBSEO 3.3.0