function for pulling certain numbers from a cell?

[datasorter]

Hello All,

Here is my question...

is there any way to use a function to pull A3 (0600) out of A1 (0600, 0625,
0630, 0700, 0702, 0703, 0706, 0708, 0772, 0829) without typing it in
manually? I know I could use =RIGHT(A1,4) for A7 but what about the others?

A1: 0600, 0625, 0630, 0700, 0702

A3: 0600
A4: 0625
A5: 0630
A6: 0700
A7: 0702

[VBA Noob]

Can't you just use text to table (by coma) and then copy and paste special > transpose ??

VBA Noob

[Gord Dibben]

One method

Data>Text to Columns>Comma Delimited>Next>Column Data Format>Text(for each
column in T to C) and Finish.

Copy>Paste Special>Transpose


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 14:10:32 -0700, datasorter
<[email protected]> wrote:

>Hello All,
>
>Here is my question...
>
>is there any way to use a function to pull A3 (0600) out of A1 (0600, 0625,
>0630, 0700, 0702, 0703, 0706, 0708, 0772, 0829) without typing it in
>manually? I know I could use =RIGHT(A1,4) for A7 but what about the others?
>
>A1: 0600, 0625, 0630, 0700, 0702
>
>A3: 0600
>A4: 0625
>A5: 0630
>A6: 0700
>A7: 0702

[Datasorter]

Hey...that worked. I appreciate it.
I was unaware that you could convert them to columns.

Thanks!

"VBA Noob" wrote:

>
> Can't you just use text to table (by coma) and then copy and paste
> special > transpose ??
>
> VBA Noob
>
>
> --
> VBA Noob
> ------------------------------------------------------------------------
> VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
> View this thread: http://www.excelforum.com/showthread...hreadid=567652
>
>