Provide space in text

[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

 

[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

 

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

 

[Pat]

If the data is contained in the same cell, simply place a

space using the space bar

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.

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.

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.

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