Delete cell data more than 122 charactor

hi lgchandana. 2 ways. formula:
=LEFT(A1,122)

another is to select the data (say A1:A10), go to Data Tab -> Text to columns -> Fixed Width -> Next -> scroll to the 122 mark & click on it to break the line -> Finish. delete column B.

@bebishiryo: you can choose not to import the column after the split, so you don't need to delete column B.

Regards, TMS

@TMShucks:
yes that's an option but:
Do not import
1. Press Next
2. select the column you dont want to import.
3. click on "Do not import"
4. Finish

Deleting
1. click Finish
2. select column B
3. Delete

roughly the same

Fair enough, but there may already be data in column B.