break up text

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" <Ciara@discussions.microsoft.com> wrote in message
news:47A4024F-4B7D-49EB-8D10-AB3946F42CBD@microsoft.com...
> 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" <Ciara@discussions.microsoft.com> wrote in message
> news:47A4024F-4B7D-49EB-8D10-AB3946F42CBD@microsoft.com...
> > 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" <Ciara@discussions.microsoft.com> wrote in message
news:96BA9A17-8693-48F0-8A07-7E61E8073156@microsoft.com...
> 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" <Ciara@discussions.microsoft.com> wrote in message
>> news:47A4024F-4B7D-49EB-8D10-AB3946F42CBD@microsoft.com...
>> > 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 exceldubai@hotmail.com

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" <Kishor@discussions.microsoft.com> wrote in message
news:CBDC2C0C-6E59-4F91-9BC3-ABFD7E3D5974@microsoft.com...
> Hi, this is kishor my email id is exceldubai@hotmail.com
>
> 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