Posted to microsoft.public.excel.misc

ado1963

Posts: n/a

Reomving a set numer of characters from a text string

Hi,

I have a column with a variable length single text string in each cell
between 9 & 36 characters. I want to consistently split or remove the
last (rightmost) 8 characters from this string, and leave the left part
of the string ( like a reverse concatanation). Is there a function to do
this?

Thanks in anticipation.

--
ado1963
------------------------------------------------------------------------
ado1963's Profile: http://www.excelforum.com/member.php...o&userid=30305
View this thread: http://www.excelforum.com/showthread...hreadid=499695

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Remove last character of text string	Grant	Excel Worksheet Functions	2	September 29th 05 05:17 PM
Extracting integers from a text string.	Bhupinder Rayat	Excel Worksheet Functions	10	September 28th 05 05:15 PM
Remove text leading zero in text string	Cheryl B.	Excel Worksheet Functions	5	May 29th 05 07:46 PM
Remove text leading zero in text string	Peo Sjoblom	Excel Worksheet Functions	0	May 27th 05 09:59 PM
Finding Specific Text in a Text String	Peter Gundrum	Excel Worksheet Functions	9	April 10th 05 07:21 PM

All times are GMT +1. The time now is 09:59 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us