Changing the text

  • Thread starter Thread starter Vincent
  • Start date Start date
V

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.
 
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
 
I want to have the formula change the contents with the "proper" function.
then putting Bell in cell C1. Then Vincent in C2
 
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
 
Back
Top