how to format Doe,John to Doe, John (space after a comma)

I have a downloaded database file with a format of "lastname,firstname" and
would like to change that one column to either one column of say lastname,
firstname (with a space after the comma) or two columns of say col1 lastname,
col2 firstname.

have a look at :
data
text to columns

--
Greetings from New Zealand
Bill K

"asuncionw" <[email protected]> wrote in message
news:[email protected]...
>I have a downloaded database file with a format of "lastname,firstname" and
> would like to change that one column to either one column of say lastname,
> firstname (with a space after the comma) or two columns of say col1
> lastname,
> col2 firstname.

You could also do a Find/Replace.

Note, Doe,John is in one column, 100 different names will carry the comma in
different places. This will not work but thanks anyway.

"Bill Kuunders" wrote:

> have a look at :
> data
> text to columns
>
> --
> Greetings from New Zealand
> Bill K
>
> "asuncionw" <[email protected]> wrote in message
> news:[email protected]...
> >I have a downloaded database file with a format of "lastname,firstname" and
> > would like to change that one column to either one column of say lastname,
> > firstname (with a space after the comma) or two columns of say col1
> > lastname,
> > col2 firstname.
>
>
>

This would help me if no formula or function is available. Thanks John.

"John Michl" wrote:

> You could also do a Find/Replace.
>
>

You can use the comma as the delimiter.
Have a go
--
Greetings from New Zealand
Bill K
"asuncionw" <[email protected]> wrote in message
news:[email protected]...
> Note, Doe,John is in one column, 100 different names will carry the comma
> in
> different places. This will not work but thanks anyway.
>
> "Bill Kuunders" wrote:
>
>> have a look at :
>> data
>> text to columns
>>
>> --
>> Greetings from New Zealand
>> Bill K
>>
>> "asuncionw" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have a downloaded database file with a format of "lastname,firstname"
>> >and
>> > would like to change that one column to either one column of say
>> > lastname,
>> > firstname (with a space after the comma) or two columns of say col1
>> > lastname,
>> > col2 firstname.
>>
>>
>>

I will try that and I think it should work. Thanks Bill.

"asuncionw" wrote:

> I have a downloaded database file with a format of "lastname,firstname" and
> would like to change that one column to either one column of say lastname,
> firstname (with a space after the comma) or two columns of say col1 lastname,
> col2 firstname.

On Thu, 3 Nov 2005 11:17:11 -0800, asuncionw
<[email protected]> wrote:

>I have a downloaded database file with a format of "lastname,firstname" and
>would like to change that one column to either one column of say lastname,
>firstname (with a space after the comma) or two columns of say col1 lastname,
>col2 firstname.


=TRIM(SUBSTITUTE(A1,",",", "))

Note the space after the second quoted comma.

The TRIM function is there just in case any of the imported names should happen
to have a space after the comma, so as not to have 2 spaces there.


--ron

Ron, it works too, thanks to you, Bill and John. Now I have 3 options.

"Ron Rosenfeld" wrote:

> On Thu, 3 Nov 2005 11:17:11 -0800, asuncionw
> <[email protected]> wrote:
>
> >I have a downloaded database file with a format of "lastname,firstname" and
> >would like to change that one column to either one column of say lastname,
> >firstname (with a space after the comma) or two columns of say col1 lastname,
> >col2 firstname.
>
>
> =TRIM(SUBSTITUTE(A1,",",", "))
>
> Note the space after the second quoted comma.
>
> The TRIM function is there just in case any of the imported names should happen
> to have a space after the comma, so as not to have 2 spaces there.
>
>
> --ron
>