Dear All,
Could you please help me in writing the code that will delete all signs following first 18 signs:
I have a column of text rows:
sadjnsjkhfjsdfhadfagagghgh\
fgdagshs hgjzfgaf nghhhf
I need a macro which will change the above text into an 18 signs long text:
sadjnsjkhfjsdfhadf
fgdagshs hgjzfgaf
I would really appreciate your help.
Thank you in advance.
In terms of formulae see LEFT function
=LEFT(A1;18)
copied down
where A1 holds original
If you need to overwrite the original data values then see the Data -> Text to Columns Feature - use Fixed With and set split to 18 (in Step 3 if preferred you may choose not to Import the 2nd column (skip))
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thanks a lot!
Last edited by Mula; 09-30-2009 at 06:02 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks