Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
I have a file for Example
Ctrl+ASelect F1Help I want cell to look like as ctrl+A Select the next cell it should be F1 Help. is there any formula to give space. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
If you are creating the entry in a formula using cells that contain text then in C1: =A1 & " " & B1 this will put a space between the text of the two cells, other than that im not sure what you mean? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38185 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
Thanks for the reply, i want for one cell?
Example A1 cell Ctrl+ASelect in B1 cell it should display as Ctrl+A Select A2 cell F1Help in B1 cell it should display as F1 Help "Simon Lloyd" wrote: If you are creating the entry in a formula using cells that contain text then in C1: =A1 & " " & B1 this will put a space between the text of the two cells, other than that im not sure what you mean? -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38185 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
It would be a seperate formula for each instance as the text length is different: =LEFT(A1,6) & " " & RIGHT(A1,6) =LEFT(A2,2) & " " & RIGHT(A2,4) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38185 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
Hi Simon,
The formula is working fine for the two examples which you have given.Thanks But now my problem is i am having text of different length. Is there one formula so that i can drag the same formula for the other cells also. If there is any formula like that would solve my problem? Ex: Ctrl+Aselect, Ctrl+BBoldFormat, Ctrl+CCopyEdit, Shift+F2Edit, Shift+F3Paste, Thanks any for u r help "Simon Lloyd" wrote: It would be a seperate formula for each instance as the text length is different: =LEFT(A1,6) & " " & RIGHT(A1,6) =LEFT(A2,2) & " " & RIGHT(A2,4) -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38185 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can i give Space/some other character in between the cell?
The short answer is no!, as you cannot determine where the split should be! -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=38185 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding (and eliminating) hidden "space" character | Excel Discussion (Misc queries) | |||
Help removing "space" character (question updated) | Excel Discussion (Misc queries) | |||
Help removing "space" character from imported data | Excel Discussion (Misc queries) | |||
How do I replace a BEL Character of 7 with a space | Excel Discussion (Misc queries) | |||
NEED HELP-----Removing a space at the end of a string of character | Excel Discussion (Misc queries) |