MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Inputting text to exiting cells


Posted by Glen on February 05, 2002 4:54 AM

Hi All

Any idea how to add the text ".1" to existing cells which already have data

e.g.
BCI .1 I need BCI.1(in the same cell)
ECP .1 I need ECP.1(in the same cell)


Posted by Chris D on February 05, 2002 12:59 PM

Hi Glen,

if BCI and ECP are in column A (rows 1 and 2 respectively)

and your .1s are in column B (rows 1 and 2 again respectively) and is TEXT rather than a number (ie 1/10th)

you can create what you need in column C as follows :

in cell C1 just enter =A1&B1

otherwise

if BCI and ECP are in column A (rows 1 and 2 respectively)

and your .1s are in column B (rows 1 and 2 again respectively) and is a number (ie 0.1 but formatted as .1)

you can create what you need in column C as follows :

in cell C1 just enter =A1&TEXT(+B1,".0")

the "&" is an instruction to concatenate.... ie glueing together.

Is this what you had in mind ?
Chris

Posted by Glen on February 06, 2002 4:36 AM

Thanks heaps Chris.

Works on a practice sheet but not on the spreadsheet I was provided, even whe I toggle with the formatting types.

The concatenate tip will be useful in teh future though.

Many Thanks

Glen