ExcelBanter - Delete 4 to 5 digits from left in a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Delete 4 to 5 digits from left in a cell (https://www.excelbanter.com/excel-discussion-misc-queries/85693-re-delete-4-5-digits-left-cell.html)

Toppers

Delete 4 to 5 digits from left in a cell

With data in A1, in B1 put

=TRIM(MID(A1,FIND(":",A1)+1,255))

copy down

"saziz" wrote:

Hi,
I got a sheet where I need to delete number followed by ':'. All these
numbers are at the left in a cell like this--- 300: text.... few
hundred rows. Any help please?
Aziz

--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=536939

All times are GMT +1. The time now is 12:03 PM.