| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting spaces between text in a cell
Can someone please tell me how to set a certain amount of spaces between text
in a given cell? Here is what I have: A1 Market Description Tucson,AZ What I want is: A1 Market Descripton Tucson,AZ All of the information is in cell A1. What I would also like to do after setting the amount of spaces between each text, is move the second category to the next cell so it will look like this: A1 A2 A3 Market Description Tucson,AZ Maybe I could skip the "spaces" issue and just figure out a way to take whatever text is set more than 2 spaces and move it to the next cell? Any answers? -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow spaces between lines of text within cell | Excel Discussion (Misc queries) | |||
| how to erase all spaces in text cell? | Excel Worksheet Functions | |||
| How to trim spaces from entered text in cell using exisiting functions? | Excel Worksheet Functions | |||
| Delete Spaces and Join Text in Cell | Excel Worksheet Functions | |||
| Setting # of Spaces for vbTab | Excel Programming | |||
![Erik K via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
