Change all the values in column A to 30 charectors in length

[aravindhan_31]

Hi,

I have some values in Column A I want to change all the values to 25 charectors in length:
eg: Aravindhan_Jyaramantest_test_test should be changed to Aravindhan_Jyaramantest_


Thanks in advance for your help.
Arvind

[NBVC]

=Left(A1,25) will cut the string in A1 to 25 chars...

You can apply formula and copy down

Then copy the new column and paste speciall >> values over the original.

[bigmack]

If data is in cell A1, then in another cell, type:

Please Login or Register  to view this content.

and that should get you from Aravindhan_Jyaramantest_test_test to Aravindhan_Jyaramantest_t

[aravindhan_31]

Hi,

Thanks for your reply, I knew this formula, and I cannot insert any more columns to type the formula. so I need this in a macro to convert the values in column A itselt.

Thanks once again.
Arvind

[bigmack]

Hi Arvind,

Try the following:

Please Login or Register  to view this content.

This will determine how many rows you have containing data, then truncate chars down to 25. Let me know if you have any further questions. If solved, please mark this thread as solved, thanks!

[DonkeyOte]

Rather than looping use Evaluate

Please Login or Register  to view this content.

[aravindhan_31]

Hi Guyes

Both the code worked for me and thanks for your help:

In the mean time I recorded a macro by selecting the column A, text to column> fixed width> pointed at 30 and the selected the next portion and marked as Do not import & finallty stoped the macro.

Its working for me

Thanks once again guyes.