Prev: splitting cell content from 1st column into 4 columns
Next: Running calculation of a frequency
From: msnyc07 on 28 Apr 2010 16:56
I've done separate functions for specific text e.g.
Manager, X = X Manager
Supervisor, X = X Supervisor

but would love if i could just make a generic
Y, X = X Y

is that doable?

Thanks in advance!
From: T. Valko on 28 Apr 2010 17:34
Try this...

=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)

--
Biff
Microsoft Excel MVP


"msnyc07" <msnyc07(a)discussions.microsoft.com> wrote in message
news:78CB9E2D-35E9-4F61-BC45-BE3D3B456DD1(a)microsoft.com...
> I've done separate functions for specific text e.g.
> Manager, X = X Manager
> Supervisor, X = X Supervisor
>
> but would love if i could just make a generic
> Y, X = X Y
>
> is that doable?
>
> Thanks in advance!


 | 
Pages: 1
Prev: splitting cell content from 1st column into 4 columns
Next: Running calculation of a frequency