Sorry, my bad

=mid($a$1,column(a1,1)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" wrote in message
...
Hi Bob, thanks. 2nd column's formula will be =mid(b1,column(b1),1) when
copy
across. It should be =mid(a1,column(b1),1). Any idea how first to default
1st
field to be 'a1' ?

"Bob Phillips" wrote:

=mid(a1,column(a1,1)

in B1 and copy across

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" <Jeff @discussions.microsoft.com wrote in message
...
I knew that Lotus 1-2-3 has Parse function but not sure if Excel has
similar
function too. Thanks.