Hello,

I have pasted values from notepad into excel. I can't however get the values
to go into seperate cells. for example cell A1 has 7 numbers seperated by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks

Hi

Select the column/range and try Data|Text To Columns. Tell the wizard that
the text is delimted and select Space as the delimiter.
Save a copy of your data before you start!


--
Andy.


"Ciara" wrote in message
...
Hello,

I have pasted values from notepad into excel. I can't however get the
values
to go into seperate cells. for example cell A1 has 7 numbers seperated by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks

That worked perfectly - thanks!!

"Andy B" wrote:

Hi

Select the column/range and try Data|Text To Columns. Tell the wizard that
the text is delimted and select Space as the delimiter.
Save a copy of your data before you start!


--
Andy.


"Ciara" wrote in message
...
Hello,

I have pasted values from notepad into excel. I can't however get the
values
to go into seperate cells. for example cell A1 has 7 numbers seperated by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks

Glad to help and thanks for the feedback!

--
Andy.


"Ciara" wrote in message
...
That worked perfectly - thanks!!

"Andy B" wrote:

Hi

Select the column/range and try Data|Text To Columns. Tell the wizard
that
the text is delimted and select Space as the delimiter.
Save a copy of your data before you start!


--
Andy.


"Ciara" wrote in message
...
Hello,

I have pasted values from notepad into excel. I can't however get the
values
to go into seperate cells. for example cell A1 has 7 numbers seperated
by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks

Hi,
After you past the numbers that are separated by spaces you select the
cell that contains the 7 numbers then click on the Data option menu
item then Text to Columns, follow the wizard and you it will see
wonders......

Cheers


--
Joseph
------------------------------------------------------------------------
Joseph's Profile: http://www.msusenet.com/member.php?userid=2505
View this thread: http://www.msusenet.com/t-1870448035

Hi, this is kishor my email id is

Please try this fuction.

Function SeparateText(TextToSeparate, WithChr, TextNo)
p = 1
i = 1
j = 0

X = Application.WorksheetFunction.Trim(TextToSeparate) & WithChr

Do Until p = 0
p = InStr(i, X, WithChr, 1)
j = j + 1
NewStr = Application.WorksheetFunction.Trim(Right(Left(X, p - 1), p
- i))

If j = TextNo Then
Exit Do
End If
If p = 0 Then Exit Do
i = p + 1
Loop
SeparateText = NewStr

End Function



"Ciara" wrote:

Hello,

I have pasted values from notepad into excel. I can't however get the values
to go into seperate cells. for example cell A1 has 7 numbers seperated by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks

Hi Folks,

For Ciara's problem, I think Excel's standard Text to Columns function would
do just fine. Try:
Data|Text to Columns|Delimited and check both 'Space' and 'Treat Consecutive
Delimiters as One'.

Cheers


"Kishor" wrote in message
...
Hi, this is kishor my email id is

Please try this fuction.

Function SeparateText(TextToSeparate, WithChr, TextNo)
p = 1
i = 1
j = 0

X = Application.WorksheetFunction.Trim(TextToSeparate) & WithChr

Do Until p = 0
p = InStr(i, X, WithChr, 1)
j = j + 1
NewStr = Application.WorksheetFunction.Trim(Right(Left(X, p - 1),
p
- i))

If j = TextNo Then
Exit Do
End If
If p = 0 Then Exit Do
i = p + 1
Loop
SeparateText = NewStr

End Function



"Ciara" wrote:

Hello,

I have pasted values from notepad into excel. I can't however get the
values
to go into seperate cells. for example cell A1 has 7 numbers seperated
by
spaces, the same for A2 and A3 etc.

2460070 -181.000000 4921.000000 587.723022 -1.758458
-1.446573 0.000000


Is there a way to get the numbers into seperate cells?

Thanks