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

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

1 Answer

Text alignment in ms publisher 2010


how about not putting the image in the text box? make them separate objects so that they don't overlap.

Apr 15, 2013 | Microsoft Publisher 2010

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

I want to find out what is meaning of cell in microsoft excel 2007 windows.


The rectangular box identified by a unique letter - number combination. You would type your number or text into this box.

A cell is the intersection of one row and one column. (EXAMPLE: A1, which refers to the cell made by the intersection of Column A and row 1.)

Nov 09, 2010 | Microsoft Office Excel 2007 Upgrade:...

1 Answer

For March in date column A2:A500 how many text entries in J2:J500


With VBA, you can write code to "loop" through that range of cells (A2:A500) and keep a count when the date is in March. With each iteration of your loop, test the value in the cell. Do the same for the other column. If this is not clear or I've misunderstood, please post back and we'll work on it more...

Apr 22, 2009 | Microsoft Business & Productivity Software

1 Answer

How to seperate a number from a text string in microsoft excel?


highlite the cells you want. right click the mouse. go to format. select text in the first coloumn.
highlite the cells you want for the second column, right click the mouse and go to format and select number and no decimal.

Jan 28, 2009 | Business & Productivity Software

3 Answers

More than 256 characters in a cell in Excel


If a RANGES
\r\n
Named Ranges. SheetLevel Named Range, Named Constants, Named Formulas ,Relative Named Ranges ,Dynamic Named Ranges ,Advanced Dynamic Named Ranges .
\r\nWorking With Ranges. FindLast cell/row/column etc.
\r\nFormula Reference Changer. Absolute to Relative etc.
\r\nSpecialCells Method
\r\nExcel Named Range Manager $
\r\nOFFSET RANGES VBA
\r\nReturns a Range object that represents a range that?s offset from the specified range. Read-only.
\r\nexpression.Offset(RowOffset, ColumnOffset)
\r\n\\"expression\\" is required and should be a Range object.
\r\n
\r\nRowOffset: Optional Variant. The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.
\r\n
\r\nColumnOffset: Optional Variant. The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.
\r\n
\r\nExample
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(RowOffset:=-1, ColumnOffset:=2).Address
\r\nEnd Sub
\r\nIs the SAME as;
\r\nSub OffsetMe()
\r\n MsgBox Range(\\"B2\\").Offset(-1,2).Address
\r\nEnd Sub
\r\nOFFSET FORMULA
\r\nReturns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.Syntax = OFFSET(reference,rows,cols,height,width)
\r\n
\r\nExamples
\r\n=OFFSET(C3,2,3,1,1) Displays the value in cell F5.
\r\n=OFFSET(C3:E5,0,-3,3,3) Returns an error, because the reference is not valid.\", \"style=\\"background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;\\"\");" style="FONT-STYLE: italic" onmouseout="GAL_hidepopup();" href="http://www.ozgrid.com/forum/autolink.php?id=5&script=showthread&forumid=8">cell is formatted as Text, then it will display the #### when the text is over the limit. Reformat the cell to General and the text should again show.

Right click on the cell, click Format Cells, under the number tab, choose General.

Also, this ####, will occur is the cell width is to small.

May 16, 2008 | Microsoft Excel for PC

2 Answers

When I enter a formula in a cell with the the insert functon device, it does not calculate itself, but shows as text


Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

2 Answers

Conversion from date to text formet


Block off the cells (or row or column) in question, right-click and choose FORMAT CELLS. In the NUMBER tab, choose TEXT. This will make your dates appear exactly as they are typed, and not allow Excel to reformat them.

Nov 18, 2007 | Business & Productivity Software

1 Answer

Need formula to get address block into columns


If you are using MS Excel then use Text to Columns from the Data menu. Simply select the column then from the Data menu click Text to Columns & follow the simple instructions in the Dialog/Wizard.

Oct 11, 2007 | Microsoft Office Standard for PC

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 Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18298 Answers

Tony

Level 3 Expert

2598 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...