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

  • Thread starter Thread starter sumit
  • Start date Start date
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.
 
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
 
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
Help finding the last space in a cell 2
Put A Space Between 2 right characters 3
Learning arrays. 13
counting the number of characters in a cell 4
trim cells with space in betwen numbers in cell 2
Using CTRL to select cells for a formula 2
Spurious Formula Omits Adjacent Cells 2

Back
Top