How to Truncate first 80 characters by keeping meaningful word in end

**Rens243** · 04-02-2013, 02:44 AM

How to truncate datas after first 80 characters by keeping meaningful word in end

**vlady** · 04-02-2013, 02:51 AM

Welcome to the forum.
Maybe to better explain your problem a sample would be better but you can experiment with this functions

=RIGHT(A1,LEN(A1)-80)
**delete 80 characters from the beginning

**Pepe Le Mokko** · 04-02-2013, 03:01 AM

Alternative : Data - text to columns - Fixed width - Insert break line at character 80

**Rens243** · 04-02-2013, 03:04 AM

How to truncate datas after first 80 characters by keeping meaningful word in end.
Thanks

**Pepe Le Mokko** · 04-02-2013, 03:12 AM

You already have two answers...

**Rens243** · 04-02-2013, 03:19 AM

Hi,
In the end words get truncated and i wont get meaningful word in end. Hence i need meaningful word in end.

**samba_ravi** · 04-02-2013, 03:47 AM

find the attachment it may help you

**Rens243** · 04-02-2013, 04:17 AM

Thanks it is working

How to Truncate first 80 characters by keeping meaningful word in end

LinkBack

Thread Tools

Rate This Thread

Display

How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Re: How to Truncate first 80 characters by keeping meaningful word in end

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions