Any Excel pro's? Need trimming sentences from other cell - GoFuckYourself.com

Naughty · 01-23-2010, 04:04 AM

Been looking for this for ages, can't this be done without programming?

We just need a short description of a long one in another cell, say 20-25 words of cell X.

Thanks

Oracle Porn · 01-23-2010, 04:11 AM

download CSVed and thank me later

Naughty · 01-23-2010, 04:38 AM

Installed, will look at it shortly. Looks promising;-)

I'll thank you later;-)

RayBonga · 01-23-2010, 04:55 AM

If I understand you correctly you should be able to do it by simply using =RIGHT(A1;25), where A1 is the cell with original text and 25 the number of characters you want

Naughty · 01-23-2010, 04:56 AM

Quote:

Originally Posted by RayBonga

If I understand you correctly you should be able to do it by simply using =RIGHT(A1;25), where A1 is the cell with original text and 25 the number of characters you want

If that works, that'd be even easier. I'll look at that tool later then as it does seem handy.

Naughty · 01-23-2010, 04:59 AM

left(a1,20) works. Thanks.

Naughty · 01-23-2010, 05:02 AM

Any idea how to combine this with some html character strip function? There's html in the long descr. causing layout issues when stripped.

NemesisEnforcer · 01-23-2010, 08:18 AM

Quote:

Originally Posted by Naughty

Any idea how to combine this with some html character strip function? There's html in the long descr. causing layout issues when stripped.

How much HTML formatting do you have in the first 20/25 characters? You could highlight the column then use Replace to change the HTML code to null.

01-23-2010, 04:04 AM	#1
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,483	Any Excel pro's? Need trimming sentences from other cell Been looking for this for ages, can't this be done without programming? We just need a short description of a long one in another cell, say 20-25 words of cell X. Thanks __________________ seks.ai for sale - ping me

01-23-2010, 04:11 AM	#2
Oracle Porn Affiliate Industry Role: Join Date: Oct 2002 Location: Icq: 94-399-723 Posts: 24,433	download CSVed and thank me later __________________

01-23-2010, 04:38 AM	#3
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,483	Installed, will look at it shortly. Looks promising;-) I'll thank you later;-) __________________ seks.ai for sale - ping me

01-23-2010, 04:59 AM	#6
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,483	left(a1,20) works. Thanks. __________________ seks.ai for sale - ping me

01-23-2010, 05:02 AM	#7
Naughty Confirmed User Industry Role: Join Date: Jul 2001 Location: Utopia Posts: 6,483	Any idea how to combine this with some html character strip function? There's html in the long descr. causing layout issues when stripped. __________________ seks.ai for sale - ping me

01-23-2010, 04:55 AM	#4
RayBonga too cool for highschool Join Date: Nov 2005 Location: East side, West side, Worldwide! Posts: 12,164	If I understand you correctly you should be able to do it by simply using =RIGHT(A1;25), where A1 is the cell with original text and 25 the number of characters you want