Jump to content

excel


phonebooth
 Share

Recommended Posts

I have an excel document an in the cell A1 I have idk how many characters, but I'm trying to truncate it down to 15 characters in cell B1.

I have this function =LEFT(A1,15) and it works but I'm trying to get my truncated text to be followed by ... and I cant seem to make that happen.

Dose anybody know how :?:

Link to comment
Share on other sites

If I remember correctly the function you are looking for is "CONCATENATE", so you would get something like =CONCATENATE(LEFT(A1,15),"...")

The skills you get from working summers in the it department of companies doing the things the real employees don't want to do...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...