Question about Microsoft Excel for PC

1 Answer

Clubing two column text into one cell

How to club two coulumn text into one column

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that gotĀ 5 achievements.

    Governor:

    An expert whose answer gotĀ voted for 20 times.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 189 Answers

This can be a tough task, even I got similar problem.
What I did is that,
I selected two columns, copied them and pasted in Textpad and then pasted back to excel, and that worked for me.

Posted on Mar 10, 2009

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Is a master switch expencive are hard to replace


It's located inside steering column and activated by a pushrod or rack and pinion type mechanisim on key switch. It requires that you drop and partially disassymble steering coulumn. I hope that is helpful, I don't know your level of mechanical ability

Mar 10, 2014 | 1994 Oldsmobile Cutlass Supreme

1 Answer

How do I text wrap in Excel 2007


  1. In a worksheet, select the cells that you want to format.
  2. On the Home tab, in the Alignment group, click Wrap Text wraptextps_za10182206.gif.
  3. Data in the cell wraps to fit the column width. When you change the column width, data wrapping adjusts automatically.
  4. If all wrapped text is not visible, it may be because the row is set to a specific height.

Feb 26, 2011 | Microsoft Office Professional 2007 Full...

1 Answer

Is it nesicary to have to replace the steering coulumn if the turning signal has been broken more than once? It's a 1979 pontiac firebird


no do not replace steering column, i have worked on countless models of this. if turn signal lever or switch is breaking often, then the work is not being done right. they are hard to do correctly. but most likely the turn signal switch or the wiper switch is binding. replace both. but them new and not used. used parts for this usually bind also.

Feb 10, 2011 | 1979 Pontiac Firebird

1 Answer

How to write vertically in microsoft word


Do this:

1.Select the text you want in Landscape orientation.
2.Click the Page Layout tab on the Ribbon.
3.Click the arrow in the lower right corner of the Page Setup group.
4. In the Apply To list box, select Selected Text or, if you want the entire document, select Whole Document.
5.Click OK.

Or, if you don't want all the text on the page turned, do this:

1. Insert a table with enough columns to enable you to isolate your vertical text in its own column.
2. Put the text in that column.
3. Right-click in that column and select Text Direction.

Now you can turn that text while the rest of the page stays horizontal. You can turn off the table cell borders so they don't print and no one will know the difference.

Hope that helps.

Jan 16, 2011 | Computers & Internet

1 Answer

2004 Intrepid transmission/coulumn shift problems


The shifter cable is adjustable in the column. Remove the column covers and see if you can adjust the cable. You problem is with the cable.

May 02, 2010 | 2004 Dodge Intrepid

1 Answer

Finding the right formula


Assumption:

  1. we work on sheet1, cell b1 as description of material and cell e1 as quantity figure.
  2. we will put the transfer the text in cell b1 to sheet2 cell a1 if you have entered some value in sheet1 cell e1. Otherwise sheet2 cell a1 will left empty or display some text as "NONE" or as you wish.
what you should do is make a formula in sheet2 cell a1 like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"")

The formula will check sheet1 cell e1, if there is any number or text put in there, the value of Sheet1 cell b1 will be copied to sheet2 cell a1. If you don't supply any number or text in sheet1 cell e1, there's nothing will appeared in sheet2 cell a1.

If you want some text will display when there's no value in sheet1 cell e1 just change the formula like this:

=IF(Sheet1!e1<>"",Sheet1!b1,"NONE")

You can modify it as your like. Just copy the formula to another row in sheet2 column a.


P.S.: If this information was helpful, please rate this solution.
1ak+f4pj7cbm32cuniyi2gaaaaaelftksuqmcc

Mar 12, 2009 | Microsoft Windows Vista Home Basic for PC

1 Answer

How to club two colums text into income colum & how to **** one colum text to different columns


whatever the software might be.. excel or word.. just select the columns.. right click.. do whatever you want.. you'll do the needful if you can read and understand english.. its very siiiiiiiimmmmppppllle..

Mar 09, 2009 | Microsoft Windows XP Home Edition

1 Answer

Sterring column feels like its stripped


The neutral sensor went out thats why it wouldn't turn on and I accidently broke the sterring coulumn so I went to the junkyard and found the same van and took off that sterring column. Now its on my van and its running better

Jan 16, 2009 | 1990 Plymouth Voyager

1 Answer

Flex Grid


The most common multidimensional array, the two dimensional array table, is best presented to your users in row and column format. The grid control offers a convenient way for you to display table data to your users. The users can navigate the table's values using scrollbars. Therefore, the grid control does not have to be as large as the table, because the grid control automatically displays scrollbars.
To add the flex grid control to your toolbox, select project and components. Add the flex grid control:
lesson97-1.jpg Once it is added, you will see the yellow flex grid control in your toolbox:
lesson97-2.jpg When you place the grid control on your form, you will have to resize it before the control takes on a tabular appearance. As you expand the size of the control, it does not look to much like a table. The problem is that the table's default number of rows and columns are two. To fix this problem, you must configure the rows and columns in the properties window:
lesson97-3.jpg lesson97-4.jpg lesson97-5.jpg The grid control supports fixed rows and columns. These refer to rows and columns in a grid control that do not scroll when the user clicks the scrollbars. The fixed rows and columns provides labels that describe the data. The fixed rows and columns are often called row and column headers.
lesson97-6.jpg When working with the grid control, much code is needed to provide the grid with functionality. Call statements are used to break the code required by the grid control into smaller, more manageable procedures. This is referred to as modular programming (which refers to the practice of placing code with a single purpose in a general subroutine procedure and then calling the code from a second procedure.)
Here is the code for the form load procedure (this example is based on the computer disk example used in the last lesson)


Private Sub Form_Load()
Call SizeCells
Call CenterCells



grdGrid.Row = 0
grdGrid.Col = 1
grdGrid.Text = "Single Sided; Low Density "
grdGrid.Col = 2
grdGrid.Text = "Double Sided; Low Density"
grdGrid.Col = 3
grdGrid.Text = "Singled Sided; High Density"
grdGrid.Col = 4
grdGrid.Text = "Double Sided; High Density"

grdGrid.Row = 1
grdGrid.Col = 0
grdGrid.Text = "3 1/2 inch"
grdGrid.Col = 1
grdGrid.Text = "$2.30"
grdGrid.Col = 2
grdGrid.Text = "$2.75"
grdGrid.Col = 3
grdGrid.Text = "$3.20"
grdGrid.Col = 4
grdGrid.Text = "$3.50"



grdGrid.Row = 2
grdGrid.Col = 0
grdGrid.Text = "5 1/4 inch"
grdGrid.Col = 1
grdGrid.Text = "$1.75"
grdGrid.Col = 2
grdGrid.Text = "$2.10"
grdGrid.Col = 3
grdGrid.Text = "$2.60"
grdGrid.Col = 4
grdGrid.Text = "$2.95"

End Sub
Notice how the form load procedure is used to populate the cells in the grid control. To control cell size and cell alignment, two smaller procedures are created and each procedure is called by the form load procedure.


Private Sub SizeCells()
Dim intColumn As Integer

grdGrid.ColWidth(0) = 1100

For intColumn = 1 To 4
grdGrid.ColWidth(intColumn) = 2200
Next intColumn

End Sub

Private Sub CenterCells()
Dim intColumn As Integer

For intColumn = 1 To 4
grdGrid.ColAlignment(intColumn) = flexAlignCenterCenter
Next intColumn

End Sub

Notice that the size and alignment procedures are only applied to columns 1 through 4. Column 0, which is a fixed column reserved for labels, is not formatted using either of the above two procedures.
Here is the final result:
lesson97-7.jpg

Mar 26, 2008 | Computers & Internet

1 Answer

Numaric to TEXT


Raju, There's no easy way to do it as far as I know. What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only Then you need to use the Vlookup function to retrieve the right text to the number you get.

Sep 15, 2007 | Microsoft Office Standard for PC

Not finding what you are looking for?
Microsoft Excel for PC Logo

Related Topics:

61 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2644 Answers

Piyal Perera
Piyal Perera

Level 3 Expert

528 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18385 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...