Any function for Crop/Cut Text

  • Thread starter Thread starter 0-0 Wai Wai ^-^
  • Start date Start date
0

0-0 Wai Wai ^-^

Hi.
How can I do the following:
- crop text from the left
eg: CropText(A1, Crop3WordFromLeft)

- crop text from the middle

- crop text from the right

- crop specific texts from left/middle/right
eg: CropText(A1, Crop_'so to speak'_If_Found_from_right )


If it is not possible, any workaround is appreciated.
 
Combinations of Replace, Left, Right, Mid, InStr, InStrRev, Split, etc. are usually how these are
done. Post examples of before and after.

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Crop text 1
Auto Cropping 6
Precision cropping in PPT2007 4
How do I crop a scanned document 1
Extract each item in the list 1
Crop out extra white space in chart 2
Crop pictures in excel,,, 5
Can I crop a PDF in PP2007 without converting it to another format 1

Back
Top