Macro to truncate string... like "Len,Left,Right formulas"

[Xx7]

I would like a macro to identify the cell to the right, shorten the string of text and place it in the active cell. I want to snip characters off both the left and right sides.

I would like a macro to perform as follows:

Run macro

Input box: "Enter the number of characters to delete from the left"

**I'll enter... say "7"

Input box: "Enter the number of characters to delete from the right"

**I'll enter... say "4"

**Then in the active cell it will produce a truncated string.

Any help appreciated!!

[Leith Ross]

Hello Xx7,

Will the macro always perform both the left and right truncations together or separately?

[Xx7]

Hello Xx7,

Will the macro always perform both the left and right truncations together or separately?

Hi Leith,

I believe together would be best

[Leith Ross]

Hello Xx7,

Perhaps this macro will work for what you want to do.

Please Login or Register  to view this content.

[Xx7]

Is there anyway to do this for a range of cells, so I don't have to run it for each individual cell. For example, if I have a column filled with strings, I would like to select a bunch of cells in the column, run the macro, and then all the cells to the right of the selected cells would be truncated.

Sorry, i'm a newb.
thx

[Leith Ross]

Hello Xx7,

This will ask you to select the range of cells to truncate.

Please Login or Register  to view this content.

[Xx7]

thx, problem solved.