ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   custom text formats (https://www.excelbanter.com/excel-discussion-misc-queries/102384-custom-text-formats.html)

tikchye_oldLearner57

custom text formats
 
hello community

can help me solve this ?

I wanted to use the "*" symbol to fill the remainder of the cell with the
specified character...

but I do not know how to do it ?

can help...much appreciated

thanks
--
oldLearner57

oldchippy

custom text formats
 

Hi oldLearner,

Is this what you want?

example

oldLearner................ Format Custom @*.

or
..............oldLearner Format Custom *.@

oldchippy :confused:


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566907


tikchye_oldLearner57

custom text formats
 
hello oldchippy

:) thanks alot for the info

best regards
--
oldLearner57


"oldchippy" wrote:


Hi oldLearner,

Is this what you want?

example

oldLearner................ Format Custom @*.

or
..............oldLearner Format Custom *.@

oldchippy :confused:


--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=566907




All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com