Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i import data from a cell in another sheet, into a textbox
I am making a worksheet in which the data is registrerd in one sheet, and
then used to generate text to paste in to an administrative system. We also use the data to generate letters to customers. The data often consist of text with varable length. And when converted to text, I often get big "gaps" between the words, and even extra lines. Seems like the fact that the text consists of data from up to 5-10 cells, makes the textprogram add thees extra space and lines. How can i incorporate the data in til the sentences, so that it looks professional and tidy? Thanks! -- Hans |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can i import data from a cell in another sheet, into a textbox
Take a look at the TRIM function, which removes extra spaces.
-- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Hans the norwegian" wrote: I am making a worksheet in which the data is registrerd in one sheet, and then used to generate text to paste in to an administrative system. We also use the data to generate letters to customers. The data often consist of text with varable length. And when converted to text, I often get big "gaps" between the words, and even extra lines. Seems like the fact that the text consists of data from up to 5-10 cells, makes the textprogram add thees extra space and lines. How can i incorporate the data in til the sentences, so that it looks professional and tidy? Thanks! -- Hans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Load ws cell data into a textbox via click on chart datapoint | Charts and Charting in Excel | |||
Import data into Excel sheet from CSV File | Excel Discussion (Misc queries) | |||
Best way to import data from an e-mail to an excel sheet? | Excel Discussion (Misc queries) | |||
Data Import from one sheet to other | Excel Discussion (Misc queries) | |||
How do I import data from 1 workbook excel sheet into another? | New Users to Excel |