Excel

  • Thread starter Thread starter Myrna K
  • Start date Start date
M

Myrna K

I am trying to complete a formula where I have two text
words in one cell... the first part of the formula takes
the first letter of first word (which I have this done),
but I also need to combine that first letter with the
second word (ex: now is... nis). Any help would be
greatly appreciated.
 
Myrna said:
I am trying to complete a formula where I have two text
words in one cell... the first part of the formula takes
the first letter of first word (which I have this done),
but I also need to combine that first letter with the
second word (ex: now is... nis). Any help would be
greatly appreciated.
Click to expand...

If "now is" is in A1, this will return "nis":

=LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,256)

Dave
dvt at psu dot edu
 
Back
Top