Jump to content

Remove characters in an excel file


teknomatika

Recommended Posts

I have an excel file. In a particular column i have a few hundred lines. In each cell I have a set of 9 characters. I have need to remove the first 5 characters of each cell. In Excel there are some functions to remove characters to the left or right, but this can only be done cell by cell.

My question: Does anyone know or have a Lisp routine that allows you to automate this task?

Link to comment
Share on other sites

Can you not use the RIGHT function in Excel? Once you have written the function for one cell, then you can copy down the function to all lines in a very short time, by dragging the square

ExcelFunc.JPG

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.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  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.

×
×
  • Create New...