function for pulling certain numbers from a cell?
 

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

function for pulling certain numbers from a cell?
 

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

function for pulling certain numbers from a cell?
 

One method

DataText to ColumnsComma DelimitedNextColumn Data FormatText(for each
column in T to C) and Finish.

CopyPaste SpecialTranspose


Gord Dibben MS Excel MVP

On Wed, 2 Aug 2006 14:10:32 -0700, datasorter
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

function for pulling certain numbers from a cell?
 

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