Text hyphens itself in Excel columns.

Asustek computer inc. / CELERON
April 17, 2013 at 01:56:07
Specs: Windows 7, Intel Celeron 331
Hello, well I have such problem, I have a word document, in this document there is table with text in it, I also have an excel document and with table in it, and I want to copy this text from word document into a table in excel, after I paste this text in excel column, the text hyphenate itself , Please help what can I do?

See More: Text hyphens itself in Excel columns.

Report •


#1
April 17, 2013 at 12:30:11
I'm not sure what you mean by "the text hyphenate itself".

When you use the word "hyphenate" I picture this:

In Word: Computer
In Excel: Com-put-er

I added "hypens", thus the text is "hyphenated".

Is that what you meant?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 18, 2013 at 02:01:43
OH Thanks a lot, just I meant this:
In Word: Computer
In Excel: Com-put-er
Please help me .
Thanks a lot.

Report •

#3
April 18, 2013 at 03:57:06
The only think that I can think of is that there are hidden characters in the text string.

In Word the characters are hidden but Excel translate them into hyphens.

You could try Find and Replace in Excel and Replace the hyphens with "nothing". In other words, leave the Replace box empty.

You might want to copy one of the hyphens into the Find box to make sure that Excel recognizes it as whatever character it really is.

Good luck!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
April 18, 2013 at 05:01:27
hi
These appear to be soft hyphens. Soft hyphens are always displayed in cells because cells don't wrap their content naturally. They disappear in web pages and when pasted into word processors because their text formatting engines support soft hyphenation.

In your case, there are no soft hyphens in your title, only in the body text.

The simplest way to remove the soft hyphens forcibly would be to replace them all with empty strings, but if you want to keep the soft hyphens while hiding them in areas that don't wrap, I'm not entirely sure of a solution, as cells in Excel don't support soft hyphenation at all.


Report •

Ask Question