LinkBack URL
About LinkBacks
Hello,
The problem that I am having is that when I move the value from a textbox to a cell, I get the paragraph marks. Is there any way to remove them?
Hello,
The problem that I am having is that when I move the value from a textbox to a cell, I get the paragraph marks. Is there any way to remove them?
You can try copying that symbol, then go to Edit|Replace and paste it there and replace with nothing....
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
What's your end goal? Should the cell show text on multiple lines in the same manner the line feeds provide in the text box? If so, just format those cells with Wrap Text.
Or do you simply want to strip out the line feeds and get run-on text? In that case you'll have to strip the characters with a REPLACE() command.
Please post your code (in code tags, please) and point out where you're looking for the adjustment.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Ok, It is actually putting a question mark in a square. When I click on the cell they disappear, but reappear when I exit the cell
This is the only code that I have for this.
It is a userform with a large typing area and the 3rd textbox (textbox3) is meant for a lot of typing from the end user. But when it transfers the symbols are there.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks