I have an excel spread sheet that has a field with the last name then comma
then first name. I want to send out some labels this weekend and I need to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me is
out until Monday.

Thank you for any assistance you can give me
--
Larry

I would first use "Data"....."Text to columns" .... "delimited" and then use
'comma' as the delimiter. This will split up the names into two columns so
that it will no be Smith in one column and Joe in the next column rather than
Smith, Joe in one column.

I would then use the following formula in another column:

=B1&" "&A1

This forumla would grab the 1st name from B1 then put a space then grab the
last name from column A and should give you 'Joe Smith'

Does that make sense?

"Larry" wrote:

I have an excel spread sheet that has a field with the last name then comma
then first name. I want to send out some labels this weekend and I need to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me is
out until Monday.

Thank you for any assistance you can give me
--
Larry

=MID(TRIM(MID(A1&", "&A1,FIND(",",A1)+1,255)),1,LEN(A1))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Larry" wrote in message
...
I have an excel spread sheet that has a field with the last name then
comma
then first name. I want to send out some labels this weekend and I need
to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me
is
out until Monday.

Thank you for any assistance you can give me
--
Larry

Thank you sir, l me try, it does make sense. I will you know
--
Larry


"tim m" wrote:

I would first use "Data"....."Text to columns" .... "delimited" and then use
'comma' as the delimiter. This will split up the names into two columns so
that it will no be Smith in one column and Joe in the next column rather than
Smith, Joe in one column.

I would then use the following formula in another column:

=B1&" "&A1

This forumla would grab the 1st name from B1 then put a space then grab the
last name from column A and should give you 'Joe Smith'

Does that make sense?

"Larry" wrote:

I have an excel spread sheet that has a field with the last name then comma
then first name. I want to send out some labels this weekend and I need to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me is
out until Monday.

Thank you for any assistance you can give me
--
Larry

Tim, thanks a million, it worked like a charm
--
Larry


"tim m" wrote:

I would first use "Data"....."Text to columns" .... "delimited" and then use
'comma' as the delimiter. This will split up the names into two columns so
that it will no be Smith in one column and Joe in the next column rather than
Smith, Joe in one column.

I would then use the following formula in another column:

=B1&" "&A1

This forumla would grab the 1st name from B1 then put a space then grab the
last name from column A and should give you 'Joe Smith'

Does that make sense?

"Larry" wrote:

I have an excel spread sheet that has a field with the last name then comma
then first name. I want to send out some labels this weekend and I need to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me is
out until Monday.

Thank you for any assistance you can give me
--
Larry

Hi Tim,

Wow!!! Instead of Concatenate, I can simply use the &. This will save me
some typing, along with the fact that I don't need to remember how to spell
cancotanete anymore :)

Thanks

"tim m" wrote:

I would first use "Data"....."Text to columns" .... "delimited" and then use
'comma' as the delimiter. This will split up the names into two columns so
that it will no be Smith in one column and Joe in the next column rather than
Smith, Joe in one column.

I would then use the following formula in another column:

=B1&" "&A1

This forumla would grab the 1st name from B1 then put a space then grab the
last name from column A and should give you 'Joe Smith'

Does that make sense?

"Larry" wrote:

I have an excel spread sheet that has a field with the last name then comma
then first name. I want to send out some labels this weekend and I need to
reverse this field so it has First name then Last name

How can I do that? I have tried for hours and the person who can help me is
out until Monday.

Thank you for any assistance you can give me
--
Larry