How to add a text (right aligned to this new text only) to the end of a range of cells

**driskill** · 11-28-2012, 10:45 PM

Good day.

- How can I restrict that only 2 lines are possible in a single cell?
- Then, how can I add text to this cell (this cell is with spellnumber) at the end of the 2nd line (right aligned for this additional text only) regardless of the length of the sentence.

Please refer to the sample below.

Sample 1:
"One hundred fifty _______________
______________________________[/U]only"

Sample 2:
"One hundred fifty and Cent sixty
five___________________________[/U]only"

The underline above denote empty. Could anyone help me?

Thanks alot!

**Muzza68** · 11-29-2012, 05:19 AM

Try the attached:

Note that cells will need to formatted as wrap text for the correct display.

Muzza68

**Marcol** · 11-29-2012, 06:47 AM

I'm not clear as to what you are trying to do.

1/. By using Data Validation you can prevent the user entering CHAR(10) more than once in any cell. CHAR(10) is alt+Enter in Excel

Select say A1 then > Data Validation
Allow:= Custom
Formula:

Formula:

Please Login or Register  to view this content.

2/. With Format > Cells > Number > Custom
Type:

Formula:

Please Login or Register  to view this content.

If you now type "One hundred fifty* in A1 it will display as "One hundred fifty______[/U]only", the number of underscores is determined by the cell width.

You can't make this part "only", red and the rest black using Custom format.

**driskill** · 11-29-2012, 11:52 PM

Thanks alot Muzza68 and Marcol! I appreciate it.

How to add a text (right aligned to this new text only) to the end of a range of cells

LinkBack

Thread Tools

Rate This Thread

Display

How to add a text (right aligned to this new text only) to the end of a range of cells

Re: How to add a text (right aligned to this new text only) to the end of a range of cells

Re: How to add a text (right aligned to this new text only) to the end of a range of cells

Re: How to add a text (right aligned to this new text only) to the end of a range of cells

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions