Thank you.
"Bob Phillips" wrote:
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.
|