Re: Converting list of numbers in Excel to a string of text in Wor

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

This worked great! Thanks for the idea. Just had to copy the last cell,
paste special --> values to a new cell, then copied that into word. I
appreciate your help!

"Pete_UK" wrote:

Assuming your numbers are in column A, put this formula in B1:

=A1

and this in B2:

=IF(A2="",B1,B1&";"&A2)

Copy this formula down as far as you need to, and the combined text
will be in the bottom cell.

Hope this helps.

Pete

On Feb 3, 9:31 pm, clint-50025 <clint-50...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
I have a list of numbers in Excel and I would like to convert this to a
string of text in either Word or Notepad. These need to be separated with a
semicolon. I have figured out how to add the semicolon in Excel (using a
formual something like "A1&B1") and then copying and pasting to a new column.
Just need to convert this list to a string with no spaces between. The end
result (in Word) would look like: 123456;246888;789456;654123...etc. Any
ideas?


.

Relevant Pages

  • Re: Semicolon problem
    ... Dim sStr As String ... For Each cell In Selection ... If ans = vbYes Then ... > Sorry guys, when i created the thread i wanted to make the wrong> semicolon BOLD, but instead it added a * at both sides of the ...
    (microsoft.public.excel.programming)
  • VB, implementing the high score within this code
    ... Private possibleAs String ... Private Function SolvePuzzleAs Boolean ... ' Calculates the possible values for all the cell ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Formulas containing hard coded values
    ... Dim R As Range, sdoit As String ... MsgBox "Cell contains hard codes" ... Dim Fml As String, LCtext As String ... For Each Rng In R.Precedents.Areas ...
    (microsoft.public.excel.programming)
  • Re: Marking points read for coordinates
    ... In "Private Sub GetCoordinates()" comment all the code between ... (ByVal lpClassName As String, ByVal lpWindowName As String) ... ' cell A1 which is the base for all object coordinates on a sheet. ... Dim chtObj As ChartObject ...
    (microsoft.public.excel.programming)
  • Re: Text formatted cells displaying numbers in scientific format
    ... When it 'sees' a large number it uses scientific format since ... I accept that Excel can't handle numbers greater than 15 digits and your ... string was 16 digits or more to be converted to a scientific value. ... It just doesn't display correctly in the cell (except after entering ...
    (microsoft.public.excel)