Abbreviate words

[Potholes]

Hi all ( I hope I have placed this request in the correct area)

I have a file that has 106 rows of data, the first column is AOK it is the second column that has quite a few different sentences that I would like to shorten.

Once I see how to do it I will try to tackle all the rows

The file is attached for perusal

Sample 1 is as they are now.

Please Login or Register  to view this content.

Sample 2 is how I would like them cut down to

Please Login or Register  to view this content.

[AliGW]

Morning, Pete!

This is quite a big ask, and will almost certainly require VBA, if it is possible at all. As with any task like this, there will need to be a set of parameters - rules - defined by you about how to change the text, and that set of rules will need to cover everything. So, for example:

Excel 2016 (Windows) 32 bit

	A	B
1	digital	dig
2	modulation	mod
3	full carrier	F/carrier

Sheet: Sheet1

In other words, you will need to be able to teach Excel your logic. The substitutions could be done with Find & Replace, or the SUBSTITUTE function, but trimming the extraneous text will be much trickier, because again you are going to need Excel to understand the logic you'd apply.

Hopefully someone versed in VBA can advise whether or not this is feasible.

To be honest, doing 106 rows manually with a mixture of F&R and text cutting would probably be faster than building and testing a VBA solution - if it were me, I'd just get stuck in. It won't take more than half an hour maximum.

[Potholes]

Good afternoon

Would it be logical then to delete my post and put it in the too hard basket please

Thanks

Peter

[AliGW]

No - we never delete threads unless they are SPAM. It remains here, just in case someone can help or as a warning to others that Excel is not human.

It perhaps ought to be moved to the VBA section - shall I do that?

[Potholes]

Please do by all means

Bonjour

[AliGW]

I've moved the thread.

You are aware that 'bonjour' cannot be used at the end of a conversation? It is a greeting, not a farewell. 'Salut', however, can be used in either case.

[YasserKhalil]

Can you give more details? Please explain the logic

[Potholes]

It has been explained to me that the complexity of my is really beyond a short answer, trimming the texts would be too hard

[AliGW]

Pete - please answer the question asked. YasserKhalil may be able to help you. He will know better than me because he knows more about VBA.

Having said this, if YOU can't explain the logic, then nobody can programme Excel to be able to implement it - that's the bottom line.

[Potholes]

Hi YasserKhalil

Basically what I need to do is to trim down each row to a minimum amount of letters from each word, in the case of

Please Login or Register  to view this content.

Down to

Please Login or Register  to view this content.

I hope this makes sense.

Thanks in advance

Peter

[AliGW]

You will need to explain the logic of what you are discarding completely, too.

[Potholes]

Hi YasserKhalil

Basically what I need to do is to trim down each row to a minimum amount of letters from each word, in the case of

Please Login or Register  to view this content.

Down to

Please Login or Register  to view this content.

I hope this makes sense.

Thanks in advance

Peter

[Potholes]

Hi all

After a conversation with the webmaster for where this information was to appear they do not need the descriptions only the first lot of numbers and letters only.

Less work for me now.

Thank you for taking an interest

Peter

[AliGW]

I thought you were the webmaster, Peter - I've just been looking at your site, as I build a few myself in my free time.

Please mark this as solved if you need no further help.

[Potholes]

Ali

This is not for my website, it is for a New Amateur Radio Organisation that is just starting up.

Thank you

Pete

[AliGW]

Ah! I see!

Thanks for marking this as solved.

Please continue here: https://www.excelforum.com/excel-for...ple-words.html

Thread closed.