Excel

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.
 
D

dvt

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Disable Outlook AutoCorrect with GPO 0
Merging from an Excel file with graphics 1
Insert name and adress from a list in a word document 1
Modern equivalent of Autotext in Word? 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
VBA - exporting serial letters to single documents 0

Top