Changing the text

[Vincent]

I would like to be able to change the content of a cell: A to contents of
cell B & C while spliting the contents at the same time.
A B C
1 BELL, Vincent | Bell | Vincent

I have seen this done but I do not know the correct for formual. I do hope
you would care to help.
Thank you in-adavance.

 

[mudraker]

I am not sure if I understand your problem
To have a1 = contents of b1 and c1 with a commar between entries ente
this formula in a1

=b1 & ", " & c1

Do not know what yoiu are after by "while spliting the contents at th
same time

 

[Vincent]

I want to have the formula change the contents with the "proper" function.
then putting Bell in cell C1. Then Vincent in C2

 

[Biff]

Hi Vincent,

You could use Text to Columns to do this but if you want
to maintain the entry in A1 also, try these formulas:

B1 =LEFT(A1,FIND(",",A1)-1)
C1 =MID(A1,FIND(",",A1)+2,255)

Biff

 

[Qwerty]

See Chip Pearson's site.
This may be what you want.
http://www.cpearson.com/excel/FirstLast.htm