Can i give Space/some other character in between the cell?

S

sumit

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.
 
S

sumit

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
 
S

sumit

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set the Length of the Cell 1
Learning arrays. 13
Using CTRL to select cells for a formula 2
Need function to return numbers at beginning of text 2
Help finding the last space in a cell 2
Put A Space Between 2 right characters 3
Spurious Formula Omits Adjacent Cells 2
trim cells with space in betwen numbers in cell 2

Top