Provide space in text

P

Pat

Where text and numbers are at different locations in different cells what
formula could be used to suit this type of information. I want to be able to
put a space between the main body of text on the left and give a space
between the text and the start of any numbers are in the cell.

Example 1:

A1 = Abelia Edward Goucher2 litre

Should be:
Abelia Edward Goucher 2 litre

Example 2:

A2 = Acer campestre Nanum180stem 6-8

Should be:
Acer campestre Nanum 180stem 6-8


Thankyou if can be of help.
Pat
 
P

pauluk

If you double clcik in the cell with the data then you can move th
blink line to were you want and hit space.

this will palce a space were you want or just type it as you requir
it.

If this is no the answer please explain your question a bit mor
 
G

Guest

If the data is contained in the same cell, simply place a
space using the space bar.

If you are concatenating data from several cells into a
single cell, include '" ";' in your concatenation string.

If you have data in multiple adjacent columns simply
adjust the column width to ensure a space.

Finally, if you are using multiple adjacent columns, you
can format the cell using a custom numerical format as
follows: " "###" litres". The result of inputing a '2'
would be ' 2 litres'. In this fashion there will alway be
a space before the numeral, you will always have the units
behind the numeral, and finally, you will be able to use
the cell contents in a formula, where if you combine the
numerals and text as cell contents you can not.
 
P

Pat

If the data is contained in the same cell, simply place a
space using the space bar
Click to expand...

There is over one thousand cells to change - time is not on my side.
If you are concatenating data from several cells into a
single cell, include '" ";' in your concatenation string.
Click to expand...

The data to be changed is contained in one cell.
If you have data in multiple adjacent columns simply
adjust the column width to ensure a space.
Click to expand...

Not relevant
Finally, if you are using multiple adjacent columns, you
can format the cell using a custom numerical format as
follows: " "###" litres". The result of inputing a '2'
would be ' 2 litres'. In this fashion there will alway be
a space before the numeral, you will always have the units
behind the numeral, and finally, you will be able to use
the cell contents in a formula, where if you combine the
numerals and text as cell contents you can not.
Click to expand...

Its not a case of formatting the cells. It will require a function, perhaps
the opposite of what TRIM does.
 
Top