Data Text to Columns

[Guest]

I have a large column and would like to split it for the literal that says
"Company Name" and then have the company name right next to it which is
enterable. I tried using Data/Text to Columns, Fixed Width, sliding the arrow
after Company Name: and it did not seem to split the column. I also tried
putting an arrow out a ways so that there looked as though there were two
defined fields and that didn't seem to work either.

Am I approaching this the right way???

HELP!!!

Thanks!

 

[Frank Kabel]

Hi
this is not possible in Excel. You have to use two columns for this

 

[Debra Dalgleish]

If the column already contains the text "Company Name" at the start of
each cell, you can use Edit>Replace to remove it (Replace "Company Name"
with nothing)

Then, select the column
Choose Format>Cells
On the Number tab, select the Custom Category
In the text box, type: "Company Name: "@
Click OK

When you enter data in the column, it will be preceded by "Company Name:"

 

[Guest]

Thanks Debra!

That worked GREAT!

Is there any way where I can do the same thing with the Date Prepared and
put today's date behind it? I tried Custom Format "Date Prepared: " TODAY()
and that did not work.

Let me know.

Thanks!

 

[Debra Dalgleish]

You're welcome!

To format a column for the date:

Select the column
Choose Format>Cells
On the Number tab, select the Date Category
Select the date format you want to use, e.g. 14-Mar-01
Select the Custom Format
In the text box, click at the beginning of the date format
Type: "Date Prepared: "
The completed entry will look something like this:
"Date prepared: "[$-409]d-mmm-yy;@
Click OK

To enter today's date, press the Ctrl key, and type a semi-colon ( ; )