MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formatting numbered lists?


Posted by Mark P on January 08, 2002 8:28 AM

I'm also trying to find a way to automate the removal of numbers from a numbered list. So, if I have a list that looks like the following:

1. lkjh Tjhfdlhf
2. Ljfdljhs
3. 24 ouyreoiure
4. ;rsdliuds

I want to be able to strip away the "1. " and JUST leave the text. Keep in mind, many of these numbered lists go past 10, so I can't just have it chop a certain number of characters off by default. Any ideas?


Posted by Shams on January 08, 2002 9:28 AM

Re: Formatting numbered lists - Try this

if your text is in Cell A1, try the following in B1

=RIGHT(A1,LEN(A1)-FIND(". ",A1))


Regards,

Shams

Posted by Mark P on January 08, 2002 10:11 AM

Re: Formatting numbered lists - Try this

That works to a certain extent, but it still leaves spaces before the actual data (ie. " ljhdjh") which I need eliminated.

Also, this routine requires an extra column, which creates an extra step. Is there any way to format a column so that it performs this operation automatically? (ie. I input "1. kjhdhs" into A1 and it puts "kjhdhs" into A1)?

Thanks

Posted by Mark W. on January 08, 2002 10:14 AM

Make that...

=TRIM(RIGHT(A1,LEN(A1)-FIND(". ",A1)))

or

=RIGHT(A1,LEN(A1)-FIND(". ",A1)-1)

if your text is in Cell A1, try the following in B1

Posted by Shams on January 09, 2002 7:16 AM

Re: I wonder why this is requred

I wondor why this is required. You want to enter "1. kjhdhs" in A1 and you want excel to change it to "kjhdhs". Then why you can't just enter "kjhdhs" instead in A1.

Regards,

Shams

That works to a certain extent, but it still leaves spaces before the actual data (ie. " ljhdjh") which I need eliminated. Also, this routine requires an extra column, which creates an extra step. Is there any way to format a column so that it performs this operation automatically? (ie. I input "1. kjhdhs" into A1 and it puts "kjhdhs" into A1)? Thanks

: I'm also trying to find a way to automate the removal of numbers from a numbered list. So, if I have a list that looks like the following